Date Time Format

Question

Hi all,

One of the date fields from my excel input appears as decimals (e.g. 44258.469444444). How do I convert this to MM/DD/YYYY? TIA

Luke_C · Answer

@Qiu  - much simpler!

Qiu · Answer

@727

ToDateTimeFunction is for the calculation of Excel DateTime format.

New Workflow3.yxmd

Luke_C · Answer

Hi @727

You can use the attached as an example on how to do this.

* I take the 'floor' of the value, which rounds down and just gets the whole number. The decimals here represent time which is not needed based on your post.
* The excel number represents number of days since 1900. You can use the datetimeadd function to add that number to 1/1/1900. We need to subtract 2 here due to some nuances with leap years and how the date functionality works.

Hope this helps!

New Workflow7.yxmd