Date Format

[#1]

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

[#2]

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.

[#3]

Brilliant! Thank you Sunny.

[its_anandrjs]

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