CF_formatTimestamp.YMD_HMS ( ~timestamp )
Convert a given timestamp to specific format: YearMonthDay_HourMinuteSecond
Be the first to rate this function Log in to vote
Thomas DS - Show more from this author
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
The result's format is export friendly and is chronologically sortable.
This example assumes that the operating system date format is set to MM/DD/YYYY.
Note that it will also work with other formats.
It is of course possible to combine this custom function with other functions, for example:
CF_formatTimestamp.YMD_HMS ( Get ( CurrentHostTimestamp ) )
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.