Convert serial date to date in "yyyy-mm-dd" format

[Jsan2758]

Hi, I need help in converting a serial date into a calendar date in the following format "yyyy-mm-dd".  For example, the input date is 43952 and the output should be 2020-05-01. 

[grossal · Accepted solution]

Hi @Jsan2758,

try this formula:

DateTimeAdd("1900-01-01",[Date]-2,"days")

It's off by 2 days, but should be constant, therefore we can subtract it and be correct in the future.

Workflow attached. Let me know if it works.

Best

Alex 

[Jsan2758]

Hi Alex, 

Thanks so much - your solution works!