MillisecondsToTimeStamp ( Milliseconds )

Function to convert milliseconds to actual timestamp

Average rating: 5.0 (1 vote) Log in to vote

Angel S. Murcia - Show more from this author
Atatiki Solutions

Sample input:

MillisecondsToTimeStamp ( 814891125000 )

Sample output:

28/10/1995 14:38:45

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

/*
Angel S. Murcia
Convert milliseconds to timestamp
*/

Let ( [ 
TimestampA = GetAsTimestamp ( ( Milliseconds ) / 1000 ) ; 
DateA = Date ( Month ( TimestampA ) ; Day ( TimestampA ) ; Year ( TimestampA ) + 1969 );
TimeA = Time ( Hour ( TimestampA ) ; Minute ( TimestampA ) ; Seconds ( TimestampA ) ) ] ; 
Timestamp ( DateA ; TimeA ) )

This custom function convert the milliseconds in actual timestamp format.

Comments

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

MillisecondsToTimeStamp ( Milliseconds )

Comments

Support this website.