community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Convert Month String to Date

Meteoroid

Hi,

 

I have a field called month, that has some month values that are in string format. I have tried to use the formula tool with an If Elseif statement going through each month to set the value to the proper corresponding month date such as 'Nov' = 11. However, when I tried this I got Null for my values. The field looks like this below

 

Month
Nov
Dec
Jan
Alteryx Certified Partner
Alteryx Certified Partner

Hi @cblades3 

 

Do you want to convert your month strings to numbers (1 to 12) or to a date (2018-01-01, 2018-02-01...2018-12-01)?

 

Cheers,

Meteoroid

Hi @Thableaus,

 

Really I want just the month number by itself  to be a date data type. 

Alteryx Certified Partner
Alteryx Certified Partner

@cblades3 

 

This is not allowed in Alteryx.

 

The date type has to follow the date format 'YYYY-MM-DD'

 

If you want the month number by itself, you need to use Int or String type.


Cheers,

Labels