Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have an issue which I know is very easy to solve, there's just something I am not quite getting right.
I have a Filter Pane which filters the dimension date. The date is showing up in the Qlik Sense formate, i.e 42370, 42401 etc.
I would like this date to be displayed in the DD MMMM YYYY format.
I have tried to do so in using the following expression: Date#([Date][, 'DD MMMM YYYY']) (Date is the name of the field containing dates). However, there's an error in my expression.
Please can someone tell me what I am doing wrong?
Thank you all in advance,
Alison
Hello,
Yes, my date field is called Date. I have now, however, renamed it DateMonthYear to avoid any confusion. But I still have the same issue.
Brilliant! Thank you Sunny.
Thanks,
It is ok if you cleansing the field in the script part and then use it on the dashboard. Or else others also suggesting correct you have to use Date(NewNUM , 'DD MMMM YYYY') in your dimension part.
Ex:-
Date(YourDateField, 'DD MMMM YYYY')
Regards
Anand