community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

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

Learn More

Date Conversions from CSV file throws errors

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?

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