DateTime in Formula tool

Question

How to transform the sales date (44075) to the standard date format (2020-09-01) using the DateTime functions in the Formula tool.

DataNath · Answer

@angelabigham As Kane says, you’re using ToDateTime() there instead of ToDate() as shown in my screenshot.

KaneG · Answer

Try running the workflow to see if it changes. Also, you want to use ToDate() rather than ToDateTime(). You may need to create a new column in order to change the Data Type (Multi-field Formula can get around this).

The other method would be using the DateTimeAdd() formula: DateTimeAdd('1899-12-30',[DateNumber],'days'). The reason that 1899-12-30 is used rather than the 31st is that Excel mistakenly thought that 1900 was a leap year back when it was originally developed and so there is an extra day in the calc.

angelabigham · Answer

The output is still null.

Screen Shot 2022-05-16 at 4.36.27 PM.png