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.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

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

inder1
5 - Atom
‎02-12-2016 07:54 AM

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?

Labels:
Reply
0
0 Likes
1 REPLY 1
RodL
Alteryx Alumni (Retired)
‎02-29-2016 01:17 PM

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.

Reply
0

Labels