12 Replies Latest reply: Aug 18, 2017 7:52 AM by Anand Chouhan RSS

    Date Format

    Alison Cooke

      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