Changing Month Year into a date in Alteryx

[kv-defy]

I have attempted changing the month year to a date using Date Time feature and it does not work. 

Attached is the excel file. I am trying to change the MMM YYYY to a legitimate date as an output. How can I do it?

[DavidSkaife · Accepted solution]

Hi @kv-defy 

Did you have the right custom format set? please see attached:

[grazitti_sapna · Accepted solution]

@kv-defy, another way to solve this problem using the formula tool.

DateTimeParse([Timeline],"%b %Y")

Thanks!