How to convert bigint value in date format

[chinnaupendra07]

hello guys,

this is Issue i am facing in big-int value i need to convert this value in ''1655251200000'' into date format is there any solution in alteryx

[binuacs · Accepted solution]

@chinnaupendra07 One way of doing this

DateTimeAdd('1970-01-01',([date]/1000), 'Seconds')

[BRRLL99]

you can try other method

use formula tool 

DateTimeParse(ToString([column_name]), "#datetime(1970,1,1,0,0,0)#")

[danilang]

Hi @BRRLL99 

Where did you find this particular DateTime format string "#datetime(1970,1,1,0,0,0)#"?  Can you show us an example of it in use?  Maybe a sample workflow?

Dan

[chinnaupendra07]

Thank you for the valuable information i get the answer @binuacs