Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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