Brian Dunning's FileMaker Custom Functions

GetAsFMTimestamp_Offset ( source ; HrsOffset ; Include_Seconds )

Similar to my other Function GetAsFMTimestamp, but provides 2 additional parameters

  Be the first to rate this function Log in to vote

Kyle Williams   Kyle Williams - Show more from this author
Dreamclinic Massage

Share on Facebook Share on Twitter

  Sample input:
GetAsFMTimestamp_Offset( "2019-05-08T00:16:34.933"; 1; 1 ) //UTC (+1hr)
GetAsFMTimestamp_Offset( "2019-05-08T00:16:34.933"; -1; 1 ) //UTC (+1hr)
GetAsFMTimestamp_Offset( "2019-05-08T00:16:34.933"; 1; 0 ) //UTC (+1hr & no seconds)
  Sample output:
5/8/2019 1:16:34 AM
5/7/2019 11:16:34 PM
5/8/2019 1:16 AM

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

This is probably one of my favorite functions and the one I'm most proud of creating as it is extremely useful. So many API integrations use a different form of timestamp and this allows you to use one simple function to transform all of the different various Timestamp formats into a FileMaker formatted timestamp that can be combined with the GetAsDate and GetAsTime functions.



Log in to post comments.


Note: these functions are not guaranteed or supported by 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 16 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: