Distance between locations
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 aLatLong
value. -
location2
- Second location as aLatLong
value.