Brian Dunning's FileMaker Custom Functions

time_format_ISO8601 ( mytime ; empty_random_null )

Returns a ISO-valid time from time or timestamp fields

  Average rating: 4.3 (35 votes) Log in to vote

Rewolfer   Rewolfer

Share on Facebook Share on Twitter

  Sample input:
time_format_ISO8601 ("23:05"; "null")
  Sample output:

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

Returns a ISO-valid time from time or timestamp fields. If timefield is empty, the second parameter specifies what to return:
- "empty" returns "" if timefield is empty
- "random" returns a random time from "00:00:01" to "23:59:59"
- "null" returns "00:00:00" (default behavior)
Functions is used by one of my other functions (timestamp_format_ISO8601ToRFC822).



Log in to post comments.


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

Under construction. Email me your wish list for improvements.