DISTANCE()

Returns the direct, straight-line distance between the two given locations, in kilometers (km) as a Decimal value. Multiply the result by 0.621371 to get the distance in miles.

Sample usage

DISTANCE([Warehouse Location], [Customer Location])  returns the distance in kilometers (km) between the two locations.

(DISTANCE([Warehouse Location], [Customer Location]) * 0.621371) returns the distance in miles between the two locations.

DISTANCE([Destination Location], HERE()) returns the distance the destination and the current location, in km. See also:  HERE()

Syntax

DISTANCE( location1 , location2 )

• location1  - First location as a LatLong value.

• location2  - Second location as a LatLong value.

See also

Capturing GPS Location

HERE()

LAT()

LATLONG()

LONG()