Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
sannidhikumar
Creator
Creator

how to get date format

Hi All ,

how to get date format .

and i am using this date(date#([Due Date],'DD-MMM-YYYY'),'MMM-YYYY') AS MonthYear1 not getting correct

output.

to Ex: Jan-2017

thanks ,

45 Replies
shanky1907
Creator II
Creator II

Can you please give a few sample values from 'Due Date' in one excel file?

sannidhikumar
Creator
Creator
Author

Capture.JPG

shanky1907
Creator II
Creator II

This is only solution i can understand in the situation:

UPPER(Date(Date#([Due Date],'DD-MM-YYYY'),'MMM-YYYY'))as MonthYear1


After reload what you get in MonthYear1 field?

sannidhikumar
Creator
Creator
Author

i am getting empty year and month.

shanky1907
Creator II
Creator II

I did the same and i have the attached result.

sannidhikumar
Creator
Creator
Author

attach it and snd me pls.