Newest functions Upload a function Leave a tip My account

There are 2,520 functions in this library.

DDtoDDM ( LatOrLon ; type )

Convert decimal degrees (DD) to degrees decimal minutes (DDM)

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

Jim Hankins Cloud Bedrock, LLC http://www.cloudbedrock.com

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

/* ========================================================= Custom Function DDtoDDM =========================================================== Purpose: Convert decimal degrees (DD) to degrees decimal minutes (DDM) Developer: Jim Hankins (jhankins@cloudbedrock.com) Adapted from original DDtoDMS by Edward Asmus Calling: DDtoDDM( latORlon; Type) of the form DDtoDDM ( "38.2065", "lat" ) The result would be 38° 12.39' N. latORlon: Decimal degrees. Values in the southern or western hemispheres would be negative values. Type: Can be either "latitude" or "longitude". "lat" or "lon" can also be used. Type can be in any case: lower, upper, or mixed. DMS: The degree symbol (°) is that used by Google Earth and Google Maps it is Unicode 176 (shift-option-8). Either latitude or longitude can be sent for conversion and it will be converted correctly. ========================================================= */ Let( [ Type = Lower ( Left ( Type; 3 ) ) ; ~hemi = Case ( ( latORlon < 0 ) and ( Type = "lat" ) ; "S" ; ( latORlon > 1 ) and ( Type = "lat" ) ; "N" ; ( latORlon < 0 ) and ( Type = "lon" ) ; "W" ; ( latORlon > 1 ) and ( Type = "lon" ); "E" ; ) ; latORlon = Abs ( latORlon ) ; ~degs = Int ( latORlon ); ~mins = ( latORlon - ~degs ) * 60 ; ~result = ~degs & "° " & ~mins & "' " & ~hemi ] ; ~result ) Click to copy

Convert decimal degrees (DD) to degrees decimal minutes (DDM). Useful for converting GPS coordinates that are often initially provided by mobile devices in decimal degrees to the degrees decimal minutes coordinate format.

 

Comments

		Fer, Spain Feb 16, 2018
I did not make any changes, but the example does not work for me, the result that shows is: 382065 ° 0 'N. I have FileMaker Pro Advanced 16

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: