datetime issue in MM-YYYY format

[ecemurun]

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

[LordNeilLord · Accepted 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

[BenMoss]

@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 

[ecemurun]

thank you! both worked! you have great community with super fast answers :)