How to transform the sales date (44075) to the standard date format (2020-09-01) using the DateTime functions in the Formula tool.
Wrapping it in ToDate() should do the trick! See below:
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 As Kane says, you’re using ToDateTime() there instead of ToDate() as shown in my screenshot.