String to Date time

[de03smita]

How to  convert 44832  to datetime ? Format: YYYY-MM-DD HH:mm:ss

[JosephSerpis]

Hi @de03smita you can use the formula todate to convert the date.

[cjaneczko · Accepted solution]

The following formula should work. 

DateTimeAdd("1900-01-01",44832-2,"days")

[de03smita]

Thank you.but for some reason it was throwing Null for me

[de03smita]

@cjaneczko it worked. Thank you.