Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Creator III
Creator III

Date format issue

Hello All,

I have below date in my table :-

Aspiring_Developer_0-1648564940246.png

 

I wish to convert them into this format:-

Aspiring_Developer_1-1648564983605.png

 

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 

 

Labels (1)
1 Solution

Accepted Solutions
aveeeeeee7en
Specialist III
Specialist III

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:

Date Format Expected Output.PNG

Hope that helps.

Regards,

AV7eN

View solution in original post

1 Reply
aveeeeeee7en
Specialist III
Specialist III

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:

Date Format Expected Output.PNG

Hope that helps.

Regards,

AV7eN