Alteryx Designer Discussions

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

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

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