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

inder1
5 - Atom

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

 USER ENDTIME
 ABC42401.043761574
 DEF 42401.045625
  

 

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

 USERENDTIME 
 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?

RodL
Alteryx Alumni (Retired)

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

 

http://community.alteryx.com/t5/Data-Sources/How-to-convert-the-Excel-numerical-date-to-date-in-Alte...

 

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.

Labels