Newest functions Upload a function Leave a tip My account

There are 2,577 functions in this library.

MillisecondsToTimeStamp ( Milliseconds )

Function to convert milliseconds to actual timestamp

  Average rating: 4.5 (2 votes) Log in to vote

Angel S. Murcia - Show more from this author Lesterius

  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 ) ; LeapYear = If ( GetAsDate ( Year ( DateA ) & "-02-29" ) = "?" and DateA > Date ( 2 ; 28 ; Year ( DateA ) ) ; 0 ; 1 ); DateA = DateA - LeapYear ; TimeA = Time ( Hour ( TimestampA ) ; Minute ( TimestampA ) ; Seconds ( TimestampA ) ) ] ; Timestamp ( DateA ; TimeA ) ) Click to copy

This custom function convert the milliseconds in actual timestamp format.

Updated: Fixed up leapt-years

 

Comments

		RAUL, UGR Feb 9, 2022
how can be included in the formated output the decimals of milisecond? for example MillisecondsToTimeStamp ( 814891125321 ) to 28/10/1995 14:38:45,321

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 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: