Date format issue

[Aspiring_Developer]

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 

[aveeeeeee7en · Accepted solution]

Hi @Aspiring_Developer,

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