Changing Month Year into a date in Alteryx

Question

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?

Months.xlsx

davidskaife · Accepted Answer

Hi @kv-defy

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

grazitti_sapna · Accepted Answer

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

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

Thanks!