Brian Dunning's FileMaker Custom Functions

UnixTime2TimeStamp ( UnixTime, time_zone_offset )

Converts Unix Time into a filemaker friendly time stamp and adjusts to local time

  Average rating: 4.1 (31 votes) Log in to vote

Michael Bateman   Michael Bateman
Bateman Productions

Share on Facebook Share on Twitter

  Sample input:
  Sample output:
6/9/2006 12:26:00.016667

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

Inspired by Tony Moller's Unix_Date (this is, I believe, the same thing in reverse). See

For a good definition of Unix Time, see

Be careful that the time zone offset takes into account daylight savings time.



Log in to post comments.


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

Under construction. Email me your wish list for improvements.