Newest functions Upload a function Leave a tip My account

There are 2,577 functions in this library.

DDtoDMS ( Latitude or Longitude ; Type )

Converts decimal degrees to degrees minutes seconds.

  Average rating: 4.6 (21 votes) Log in to vote

Edward P. Asmus Asmus Consulting http://asmus.uga.edu

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

/* ========================================================= Custom Function DDtoDMS =========================================================== Purpose: Convert decimal degrees (DD) to degrees minutes seconds (DMS). Developer: Edward Asmus (edasmus@uga.edu) Calling: DDtoDMS( latORlon; Type) of the form DDtoDM ( "38.2065", "lat" ) The result would be 38° 12' 23" 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. Reference: http://www.rapidtables.com/convert/number/degrees-to-degrees-minutes-seconds.htm ========================================================= */ 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 = Int ( ( latORlon - ~degs ) * 60 ) ; ~secs = Round ( ( latORlon - ~degs - ~mins / 60 ) * 3600; 0 ) ; ~result = ~degs & "° " & ~mins & "' " & ~secs & "\" " & ~hemi ] ; ~result ) Click to copy

Converts decimal degrees (DD) to degrees minutes seconds (DMS). The function is called with a latitude or longitude in decimal degress and the type. The type can be either "latitude" or "longitude" and these may be shortened to "lat" or "lon". The type can be in any case: upper, lower, or mixed.

 

Comments

		Sep 14, 2019
this is giving me an error on the latORlon, it is not defined.

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 21 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: