In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Convert String format to Year and Month

FECL3
8 - Asteroid

I am looking to convert string format of "201201" to a Year and month format of "01-2012"

 

Any help would be greatly appreciated

3 REPLIES 3
JosephSerpis
17 - Castor
17 - Castor

Hi @FECL3 I mocked up a workflow that produces the output you describe in a few different ways.

FECL3
8 - Asteroid

Thank you for the response. I want the output in a date format (mm-YYYY) however, when I change the output of the formula to date it does not run as expected. How would I correct this?

JosephSerpis
17 - Castor
17 - Castor

Hi @FECL3 Alteryx only recognises YYYY-MM-DD as a valid date format hence when you change the data type to data in formula tool it does not work. If you want the format mm-YYYY then it will need to be a string field like in the workflow I previously posted. This link explains in more detail Datetime Function in alteryx. If you read the section about Datetime Format it shows that the data types needs to be a string.

 

DateTimeFormat(dt,f): Converts date-time data from ISO format to another specified format (f) for use by another application. Output to a string data type.

Labels
Top Solution Authors