Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.

Converting to Data format

prakashatutd
8 - Asteroid

Hello:

In the sdelivery.csv file, date of delivery is given as number (e.g., 45235)

Question: How to convert this field to "Date" format?

 

The data and workflow files are attached.

 

Thanks

1 REPLY 1
alexnajm
17 - Castor
17 - Castor

Here is a post about it: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-convert-the-Excel-numer...

 

but also the ToDate function should work!