Question

Timestamp Conversion

Forum|Forum|4 years ago
April 7, 2022
5 replies
0 views

I was looking for a function that converts standard unix millis to a timestamp. I came across datevalue() but that is based on an Appian epoch of 1/1/2035 instead of 1/1/1970. Short of figuring out the number of milliseconds between those two dates and subtracting the difference, is there some other way to get that time stamp?

Also, while on the subject, why did Appian choose to base their epoch on some time in the future?

timestamp

stefanhelzle0001

Brainy

I had to do that a few years ago. I do not know of a OOTB way.

I have no idea why they chose that epoch. But in Appian we typically do not have to deal with this and live in UTC world.

marcot0005Author

Yeah, normally not an issue, but I've got an api sending me the timestamp in Unix millis. I managed to find a plugin just after posting that handles it (Date and Time Utilities), so I guess I'll be using that.