ConvertTimeStamp ( unixTimeStamp )
Convert unix timestamp to FMP timestamp
Average rating: 4.2 (37 votes) Log in to vote
NRG Software, LLC.
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Unix bases its time values on the number of seconds since midnight (00:00:00) on 1 January 1970. FMP bases it's time values on the number of seconds since 1/1/1900.
|Thomas Seidler, London
Sep 20, 2010
|Timestamp ( Date ( 1 ; 1 ; 1970 ) + _unixTS / 86400 ; Mod ( _unixTS ; 86400 ) )
to convert to FileMaker timestamp (as opposed to date).
Jan 7, 2012
|"FMP bases it's time values on the number of seconds since 1/1/1900."
should be year 0001 not 1900.
|Terry Morse, Palo Alto, CA USA
Aug 20, 2015
|Here's my function that accounts for local time zone offsets:
(GetAsNumber (timestamp_unix) )
+ GetAsNumber (Timestamp ("01/01/1970" ; "00:00:00") )
+ GetAsNumber(Get(CurrentTimestamp) )
- Floor( Get (CurrentTimeUTCMilliseconds)/1000 )
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.