Brian Dunning's FileMaker Custom Functions

MilliTimestamp ( OffsetTimeFromUTC )

Get Timestamp data with milli-seconds.

  Average rating: 4.6 (27 votes) Log in to vote

Koji Takeuchi   Koji Takeuchi
TonicNote, Inc.
https://tonic-note.com

Share on Facebook Share on Twitter

  Sample input:
MilliTimestamp ( "-8:00" )
  Sample output:
08/28/2012 20:40:12.013

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

MilliTimestamp ( OffsetTimeFromUTC )
2012.09.09, Koji Takeuchi


description:
Get Timestamp data with milli-seconds.
ex1.
MilliTimestamp ( "9:00" )
= 08/29/2012 13:40:12.013
// Timestamp data of Japanese Standard Time with milli-seconds.
ex2.
MilliTimestamp ( "-8:00" )
= 08/28/2012 20:40:12.013
// Timestamp data of US Pacific Time with milli-seconds.
// If you want to get DST, set "-7:00" to OffsetTimeFromUTC.
ex3.
MilliTimestamp ( "" )
= 08/29/2012 04:40:12.013
// Timestamp data of UTC with milli-seconds.
*/

 

Comments

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.

Under construction. Email me your wish list for improvements.