Newest functions Upload a function Leave a tip My account

There are 2,521 functions in this library.

FormatTimestamp ( format ; tstamp )

Formats a time/date any way you like using a format string

  Average rating: 4.4 (30 votes) Log in to vote

Tim Mansour - Show more from this author

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

/* Function FormatTimestamp ( format ; tstamp ) Formats a timestamp according to format, replacing placeholders with date/time data. If tstamp is a null string ("") then the current date/time are used. */ Let ( [ indata = If ( GetAsText ( tstamp ) = "" ; Timestamp ( Get ( CurrentDate ) ; Get ( CurrentTime ) ) ; // default to now // else tstamp ) ; hr = Hour ( indata ) ; hr12 = Mod ( hr - 1 ; 12 ) + 1 ] ; Substitute ( format ; [ "[HH]" ; Right ( "0" & hr ; 2 ) ] ; [ "[H]" ; hr ] ; [ "[hh]" ; Right ( "0" & hr12 ; 2) ] ; [ "[h]" ; hr12 ] ; [ "[mm]" ; Right ( "0" & Minute ( indata ) ; 2 ) ] ; [ "[m]" ; Minute ( indata ) ] ; [ "[ss]" ; Right ( "0" & Seconds ( indata ) ; 2 ) ] ; [ "[s]" ; Seconds ( indata ) ] ; [ "[am]" ; If ( hr < 12 ; "am" ; "pm" ) ] ; [ "[pm]" ; If ( hr < 12 ; "am" ; "pm" ) ] ; [ "[AM]" ; If ( hr < 12 ; "AM" ; "PM" ) ] ; [ "[PM]" ; If ( hr < 12 ; "AM" ; "PM" ) ] ; [ "[Dayname]" ; DayName ( indata ) ] ; [ "[dayname]" ; Lower ( DayName ( indata ) ) ] ; [ "[DAYNAME]" ; Upper ( DayName ( indata ) ) ] ; [ "[Day]" ; Left ( DayName ( indata ) ; 3 ) ] ; [ "[day]" ; Lower ( Left ( DayName ( indata ) ; 3 ) ) ] ; [ "[DAY]" ; Upper ( Left ( DayName ( indata ) ; 3 ) ) ] ; [ "[DD]" ; Right ( "0" & Day ( indata ) ; 2 ) ] ; [ "[D]" ; Day ( indata ) ] ; [ "[MM]" ; Right ( "0" & Month ( indata ) ; 2 ) ] ; [ "[M]" ; Month ( indata ) ] ; [ "[Month]" ; MonthName ( indata ) ] ; [ "[month]" ; Lower ( MonthName ( indata ) ) ] ; [ "[MONTH]" ; Upper ( MonthName ( indata ) ) ] ; [ "[Mon]" ; Left ( MonthName ( indata ) ; 3 ) ] ; [ "[mon]" ; Lower ( Left ( MonthName ( indata ) ; 3 ) ) ] ; [ "[MON]" ; Upper ( Left ( MonthName ( indata ) ; 3 ) ) ] ; [ "[YYYY]" ; Year ( indata ) ] ; [ "[YY]" ; Right ( Year ( indata ) ; 2 ) ] ) ) Click to copy

Formats a timestamp according to a format string, replacing date/time component placeholders with respective data. See the Substitute command in the function to determine (or change) the placeholders to use. Includes placeholders to allow upper/lower case for text components (eg, day names).
Use a null input timestamp ("") to format the current date/time.

 

Comments

		simon Plint, Australia Mar 24, 2010
hr12 = Mod ( h - 1; 12 ) + 1 should be hr12 = Mod ( hr - 1; 12 ) + 1 ["[am]"; If ( h < 12; "am"; "pm" )]; should be ["[am]"; If ( hr < 12; "am"; "pm" )];

		Tim Mansour Mar 24, 2010
I've updated the function to my latest version.

		Kevin Smith, London Jun 3, 2015
Watch out for when keying in the formatting parameters. The case of the parameter often controls the case of the output e.g. "[month]" vs "[MONTH]". Here's an exception: The parameter "[mm]" generates minutes while the parameter "[MM]" generates months.

		Tony White, Tony White Designs, Inc. Oct 1, 2022
Thanks! Posted some thoughts here... https://the.fmsoup.org/t/whats-a-custom-function-youve-created-that-you-think-should-be-built-in-to-filemaker/3091/32

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. 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 20 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: