Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
Our main navigation will be under construction for the next hour. "Launch Pad" will be moving to "Learn", and the "Introduce Yourself" forum will be moving to a thread in the "General" discussion.

Alteryx Designer Desktop Discussions

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

Date Conversions from CSV file throws errors

5 - Atom

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 Year....is 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.