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
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).
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.