Date format issue

Aspiring_Developer — Tue, 29 Mar 2022 14:44:12 GMT

Hello All,

I have below date in my table :-

I wish to convert them into this format:-

I tried to give format like Date (Date field, 'MMM-YY') but it is giving me blank result.

Can anyone please help ?

Thanks in advance

Re: Date format issue

aveeeeeee7en — Tue, 29 Mar 2022 15:10:37 GMT

Your ISSUE_CLOSED_DATE is in Text format.

You need to first convert your original date to a number format which is actually the internal representation of Date.

Try this:

DATE(DATE#(Issue_Closed_Date,'DD-MMM-YYYY'),'MMM-YY') AS Issue_Closed_Date_Month

Expected Output:

Hope that helps.

Regards,

AV7eN