Date format Change

[mmustkee]

Hi Team,

Kindly refer attached sheet. We receive data in the format updated in column "A" and wants result as column "E". Could yu please fix the same in Alteryx as column "E".

Thanks for your help in advance.

Thanks,

Mohammad Mustkeem

[Emil_Kos]

Hi @mmustkee,

Can you also make a screen as for me it is translating me to Polish. I wonder how the output looks for you.

[mmustkee]

Hi 

I actually want column "A" to be formatted into date format and result should be as column "E". 

Please help.

Thanks,

Mohammad Mustkeem

[Emil_Kos]

Hi @mmustkee,

This is the formula you need:

DateTimeParse([Invoice Month],'%b-%y')

The output:

[mmustkee]

Hi,

Please find screen below:

[mmustkee]

Hi,

I need my my result as Dec-20 as date format not 2020-12-1.

Thanks for your response.

[Emil_Kos · Accepted solution]

Hi @mmustkee,

If you have a date in proper date format you can use this formula:

DateTimeFormat([Date],'%b-%y')

[mmustkee]

Perfect.

That worked for me.