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?
Discussion posts and replies are publicly visible
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.
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.
OK. I had a quick look at the plugins as well, but did not find it. Good to hear you got a solution.
I'm looking for a tool with a similar function Super Mario Bros
https://community.appian.com/b/appmarket/posts/date-and-time-utilities
That's the plugin I ended up using