Brian Dunning's FileMaker Custom Functions


Converts a FileMaker timestamp to ISO 8601 YYYY-MM-DDTHH:MM:SS

  Be the first to rate this function Log in to vote

David A Sullivan   David A Sullivan - Show more from this author
Mandelbrot LLC

Share on Facebook Share on Twitter

  Sample input:
FMtoISO8601 ( "3/8/2021 9:34:16 PM" )
  Sample output:

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

A lot of javascript libraries need ISO 8601 formatted timestamps.

While it makes sense to a lot of JavaScript developers, formating your dates with the largest unit of time first (years), then descending down to the smallest unit (seconds), it sure does confuse users.

So, with this custom function, you can take a typical FileMaker timestamp like this:

3/11/2021 11:23:50 AM

And make it look like this:




Log in to post comments.


Note: these functions are not guaranteed or supported by 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 16 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: