Convert unix timestamp while removing first characters

Question
1

Hey there

I ran into problems while converting a date which I get from an api into human readable format.

"CreateDate": "/Date(1430960032857)/"

I tried it with a formula, removing /Date ( )

DATETIME(REPLACE_ALL(REPLACE_ALL(REPLACE_ALL(appVars.AppUser[0].UpdateDate, "/Date", ""), "(",""),")/",""))

So when I try the formula without DATETIME it looks good and returns me 1430960032857 alone. As soon as I add DATETIME it doesn’t work.

Thanks for your help
Andreas

2

Hi, use NUMBER() still around the timestamp, DATETIME() doesn’t understand timestamps inputted as strings

1 Like