How do i show in a formula a Unix time field e.g 1631484422672 into a readable format with date time and seconds ?
Cant be that hard but cant seem to find any info on it.
Sounded familiar, found an old note from when I was working with support regarding extracting prompt values from the audit database…
=RelativeDate( ToDate(“01/01/1970 00:00:00” ; “MM/dd/yyyy HH:mm:ss” ) ; 1632859440 ; SecondPeriod )
Have a note that using milliseconds doesn’t work “as expected”. Not sure if it’s been fixed or not… looks like it still doesn’t work.
If your time is in milliseconds, you can try:
=RelativeDate( ToDate(“01/01/1970 00:00:00” ; “MM/dd/yyyy HH:mm:ss” ) ; ( 1631484422672 / 1000 ) ; SecondPeriod )