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.
Solved! Go to 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
Hi Alex,
Thanks so much - your solution works!