Brian Dunning's FileMaker Custom Functions

FormatTimestamp ( _ts ; _f )

PHP standards 4 timestamp, date and time formatting

  Average rating: 3.7 (53 votes) Log in to vote

ThomasSeidler   ThomasSeidler - Show more from this author
The Good Book Company Ltd
http://www.thegoodbook.co.uk

Share on Facebook Share on Twitter

  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

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

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

 

Comments

Thomas Seidler   Thomas Seidler, London, UK
May 6, 2009
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...
 

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: