Shopping Cart

Search:

Signup

Contact

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

# FileMaker Pro Custom Functions

HaversineDistance ( latx ; lony ; laty ; lony ; units )

Rate this function:

Discuss this Custom Function

john renfrew, attitude
http://fmtopdf.com

compute shortest distance

Sample Input:
 HaversineDistance ( 36.12 ; -86.67 ; 33.94 ; -118.4 ; "" )
Sample Output:
 1794 mi 105.88 yds

Then copy & paste into FileMaker Advanced's Edit Custom Function window.

## Description:

The haversine formula is an equation important in navigation, returning great-circle distances between two points on a sphere from their longitudes and latitudes.

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

This is my Custom Function and I want to edit it

## Discuss:

Just to repay the compliment John, you a typo or 2!

HaversineDistance ( latx ; lony ; lat y ; lony ; units )
should be

HaversineDistance ( latx ; lonx ; laty ; lony ; units )?

Tim

Tim Anderson, Larbert
March 04, 2015 1:53pm

Tim
Well spotted Mr Darcy...
Jeremy Bante's custom function uses the more complex Andoyer-Lambert-Thomas method if the coordinates are in the WGS84 coordinate system, and is more accurate, but this is within 99.98% of that, so for use in short distance calculations is as effective

https://github.com/jbante/FileMaker-Techniques/blob/master/Cus tomFunctions/Location/LocationDistanceValues.fmfn

john renfrew, curdworth
March 04, 2015 4:58pm