Shopping Cart

Free Newsletter
Signup

Contact me | vCard

Brian on CNN

Brian on CBS Radio

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

FileMaker Pro Custom Functions

List | Show Random | Upload | Add This to Your Site

FormatTimestamp ( _ts ; _f )

Rate this function:

Average rating: 2.9 (9 votes)
Discuss this Custom Function

Thomas Seidler, The Good Book Company
http://harmlesswise.com/it

PHP standards 4 timestamp, date and time formatting

Sample Input:

FormatTimestamp(Get(CurrentDate); "Y-d.m")

FormatTimestamp(Get(CurrentTime); "g:ia")

FormatTimestamp(Get(CurrentTimestamp); "RFC822")

FormatTimestamp(Get(CurrentTimestamp); "d.m.y - H:i:s")

Sample Output:

2009-6.5

4:44pm

Wed, 06 May 09 16:44:47

06.05.09 - 16:44:47

/* wanted a standards based function for this - based on http://uk3.php.net/manual/en/function.date.php _ts - timestamp _f - format string recursive to go thru each character */ Let ( [ // substitution for constant expressions - i.e. submit RFC822 and away-ish you go - u still need to add timezone stuff to end afterwards... _f = Substitute (_f ; ["RFC822" ; "D, d M y H:i:s"]; ["RSS"; "D, d M Y H:i:s"]); _c = Left(_f;1) ; _lf = Length(_f); _f = Right(_f; _lf-1); _result = Case ( // DAY Exact(_c; "d" ) ; Right ( "0" & Day( _ts ) ; 2 ) ; Exact(_c; "D") ; Left( DayName( _ts ) ; 3 ) ; Exact(_c; "j" ); Day ( _ts ) ; Exact(_c; "l") ; DayName ( _ts ) ; Exact(_c; "N") ; Mod ( DayOfWeek ( _ts ) -2 ; 7 )+1 ; Exact(_c; "S" ); /* number_Ordinal_Suffix ( Day ( _ts) ) */ "" ; Exact(_c; "w" ); DayOfWeek ( _ts ) - 1 ; Exact(_c; "z") ; DayOfYear ( _ts ) ; // WEEK Exact(_c; "W") ; WeekOfYearFiscal ( _ts ; 2 ) ; // MONTH Exact(_c; "F" ); MonthName ( _ts ) ; Exact(_c; "m") ; Right ( "0" & Month ( _ts ) ; 2) ; Exact(_c; "M") ; Left ( MonthName ( _ts ) ; 3 ) ; Exact(_c; "n") ; Month ( _ts ) ; Exact(_c; "t"); Day ( Date ( Month(_ts)+1 ; -1 ; Year(_ts) ) ) ; // YEAR // leap year calc nicked from http://www.mitre.org/tech/cots/LEAPCALC.html Exact(_c; "L") ; Let ( _y = Year(_ts); Case ( Mod ( _y ; 4 ) ≠ 0 ; 0 ; Mod(_y;400)=0; 1; Mod(_y;100)=0; 0; 1) ) ; Exact(_c; "o"); If ( WeekOfYearFiscal ( _ts ; 2 ) > 51 and Day(_ts)<7 ; Year(_ts)-1 ; Year(_ts) ) ; Exact(_c; "Y") ; Year(_ts); Exact(_c; "y"); Right(Year(_ts); 2); // TIME Exact(_c; "a"); If(Hour(_ts)>=12; "pm"; "am") ; Exact(_c; "A"); If(Hour(_ts)>=12; "PM"; "AM") ; Exact(_c; "g"); Mod( Hour(_ts)-1;12)+1; Exact(_c; "G"); Hour(_ts); Exact(_c; "h"); Right( "0" & Mod(Hour(_ts)-1;12)+1; 2); Exact(_c; "H"); Right ("0" & Hour(_ts); 2); Exact(_c; "i"); Right("0" & Minute(_ts); 2); Exact(_c; "s"); Right("0" & Seconds(_ts); 2); _c ) // end of case ] ; _result & If(_lf>1; FormatTimestamp (_ts; _f) ) )
Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed

Description:

I looked at http://www.briandunning.com/cf/893, but wanted something to be using Timestamps, so either date or time i pass, it can format nicely... i think this is a nice generic function, and cos it uses Exact, u can add to it without worrying about substitution order etc...

To learn format options go to: http://uk3.php.net/manual/en/function.date.php

Timezone stuff don't work. If you wish to go the extra mile and get that working go for it and email me at tom "@t" seidler [dot] co_uk and i'll update this...

I've commented out the ordinal suffix option, cos it depends on another custom function, but kind of useful (http://www.briandunning.com/cf/118).

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

This is my Custom Function and I want to edit it

Discuss:

apologies to any who've used this so far, a few bugs, you know how it is with Mod(x - 1; divisor)+1 etc - i left em out in some places... notably the g and h, just corrected...

get in touch if u find any bugs...

Thomas Seidler, London, UK
May 06, 2009 7:30pm

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1.	SUMLIST ( list )
	(Mon, Feb 08, 1:43pm)
2.	RemoveSmartQuotes (text)
	(Sun, Feb 07, 9:25pm)
3.	ParseAllBetween ( source ; start ; stop ; startPos ; result )
	(Sun, Jan 31, 12:50pm)
4.	ParseBetween ( source ; start ; stop )
	(Sun, Jan 31, 12:44pm)
5.	GetValueCustom ( text ; delimiter ; valueID )
	(Mon, Jan 25, 7:12pm)
6.	List2 ( RelatedField )
	(Sun, Jan 24, 4:06pm)
7.	MultiLineKey ( input ; size ; output )
	(Tue, Jan 19, 9:26pm)
8.	DeduplicateList ( input ; output )
	(Tue, Jan 19, 9:16pm)


			[ Close Window ]
	The class that teaches you how to successfully sell your FileMaker Pro solution as a professional shrinkwrapped software application.
	Let's Meet in Person Sunday, August 13 2006, Orlando FL Courtyard Orlando International Drive
	Don't miss this most important day of the Developer Conference. Please click here for complete details and online registration.

FileMaker Pro Custom Functions

Description:

Discuss:

Let's Meet in Person