topic datetime issue in MM-YYYY format in Alteryx Designer Desktop Discussions

datetime issue in MM-YYYY format

ecemurun — Mon, 25 Jun 2018 09:03:10 GMT

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

Re: datetime issue in MM-YYYY format

LordNeilLord — Mon, 25 Jun 2018 09:09:13 GMT

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

Re: datetime issue in MM-YYYY format

BenMoss — Mon, 25 Jun 2018 09:12:25 GMT

@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

Re: datetime issue in MM-YYYY format

ecemurun — Mon, 25 Jun 2018 10:49:57 GMT

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