Date Format Parse - From YYYY-mm-dd to Mon-YYYY in date format not in String format.

[Falcon8273]

Hi,

Please help me to convert the date 2020-12-25 to Dec-2020. I want the output ( Dec-2020 ) in Date format not in String format.

I tried formula and Date parse tool. I couldn't get the desired output.

Kindly help me.

Thanks,

Kishore

[atcodedog05]

Hi @Falcon8273 ,

The proposed approach would be.

Take first day of month for each day so it always represents the month. Do all the actions then at the end change the format.

Hope this helps. Please let me know.

[Falcon8273]

@vizAlter - Thank you  so much for your help. It worked.

[vizAlter · Accepted solution]

@Falcon8273  - Thank You!