Solved: Re: Date format - Qlik Community

qlikapple · ‎2020-01-21

Hi , I have date as 05-NOV-19

I need to change it as Nov 19, can anyone please help

Taoufiq_Zarra · ‎2020-01-21

may be :

=(Date(Date#('05-DEC-19','DD-MMM-YY'), 'MMM YY'))

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

Taoufiq_Zarra · ‎2020-01-21

may be :

=(Date(Date#('05-DEC-19','DD-MMM-YY'), 'MMM YY'))

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

Date format