Brian Dunning's FileMaker Custom Functions


Time offset from GMT

  Be the first to rate this function Log in to vote

Rob Poelking   Rob Poelking - Show more from this author
Excelisys, Inc.

Share on Facebook Share on Twitter

  Sample input:
  Sample output:
-4 //for Eastern Daylight Time

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

Returns the number of hours offset from GMT for your location. No more fumbling to adjust for daylight savings as long as the host computer or server automatically adjusts for it, then this evaluation will allow you to determine the offset as needed. Helpful when making REST API calls where the time evaluation is from GMT when making calls from your local computer.



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: