This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The highly anticipated Alteryx Community tradition is back! We hope you'll join us!
I have date column in the csv file as string data type in the form of excel numeric date.
Ideally I am trying to get the out put as here under
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?
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.