Hi,
I have a data set like below. I am trying to convert the data type from string to date, so I can sort by dates. However, the datetime_out I receive is null when using datetime tool. Do you have any suggestion of doing this by using another tools or how can I do that by datetime tool?
Thank you!
(Data format is 'string')
01/2017
01/2018
02/2017
02/2018
03/2016
03/2017
03/2018
04/2016
04/2017
04/2018
Solved! Go to Solution.
Hey @ecemurun
Here's both methods for you :)
DateTime Tool:
Formula tool
For future reference....this webpage is incredibly helpful https://help.alteryx.com/9.5/Reference/DateTimeFunctions.htm
@LordNeilLord beat me to this one but I'll give another suggestion, you can use a simply formula in this instance such as...
right([field],4)+"-"+left([field],2)+"-01"
Create this as a new field and set the data type to date.
Ben
thank you! both worked! you have great community with super fast answers :)