distanceToTarget ( targetLat ; targetLng ; startLat ; startLng )

Returns distance between two sets of gps coordinates in metres.

Average rating: 5.0 (1 vote) Log in to vote

Jonni™ - Show more from this author

Sample input:

distanceToTarget ( 41.40338 ; 2.17403 ; 40.748440 ; -73.984559 )

Sample output:

6161803.086571954891149

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let ( [
	
	~lat = targetLat ;
	~lng = targetLng ;
	~glat = startLat ;
	~glng = startLng
] ;

	Acos ( Sin(~lat*Pi/180)*Sin(~glat*Pi/180) + Cos(~lat*Pi/180)*Cos(~glat*Pi/180)*Cos(~glng*Pi/180-~lng*Pi/180) ) * 6371000

)

// BD Link : https://www.briandunning.com/cf/2658
// Written by: jonni@me.com
// V 1.0

Returns distance between two sets of gps coordinates in metres.

Comments

		David A Sullivan, Mandelbrot LLC Apr 8, 2023
coooooooooool

		Benedick Miller May 14, 2024
very nice, very useful, thank you!

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

distanceToTarget ( targetLat ; targetLng ; startLat ; startLng )

Comments

Support this website.

Support this website.