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

Sample input:

FormatTimestamp.YMD_HMS ( "02/01/1970 12:11:10" ) // here in MM/DD/YYYY format

Sample output:

19700201_121110

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

Let(
   [
      ~z = "0";
      // zero
      ~u = "_";
      ~year = Year( ~timestamp );
      ~month = Month( ~timestamp );
      ~day = Day( ~timestamp );
      ~hour = Hour( ~timestamp );
      ~minute = Minute( ~timestamp );
      ~seconds = Seconds( ~timestamp );
      ~formatYMD = ~year & Right( ~z & ~month; 2 ) & Right( ~z & ~day; 2 );
      ~formatHMS = Right( ~z & ~hour; 2 ) & Right( ~z & ~minute; 2 ) &
      Right( ~z & ~seconds; 2 )
   ];
   ~formatYMD & ~u & ~formatHMS
)

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 ) )

Comments

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

FormatTimestamp.YMD_HMS ( ~timestamp )

Comments

Support this website.

Support this website.