datetime issue in MM-YYYY format

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

Datasets

Accepted answers

LordNeilLord

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

All comments

LordNeilLord

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703