Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Date Conversions from CSV file throws errors


I have date column in the csv file as string data type in the form of excel numeric date.

 DEF 42401.045625


Ideally I am trying to get the out put as here under

 ABC 2/1/2016  1:03:01
DEF2/1/2016  1:05:42


I tried the date time tool to convert the string to the desired date format but it gives an error as "DateTime_Out:Invalid not a valid number record#.."


Any help on this?

Alteryx Alumni (Retired)

I think you have the basics in a different post you made here...


Check out my idea there for splitting the number into a whole number and decimal and treating the time part of it independently, and then merging them back together.