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
http://batemanproductions.com

Share on Facebook Share on Twitter

  Sample input:
UnixTime2TimeStamp(1149855960.016667;-7)
  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 http://www.briandunning.com/cf/64

For a good definition of Unix Time, see http://en.wikipedia.org/wiki/Unix_Time

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

 

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.