27 Replies Latest reply: Jun 19, 2017 7:21 AM by Alison Cooke RSS

    Coverting Date from DD/MM/YYYY to MM/YYYY

    Alison Cooke

      Hello,

       

      I have a table in which one of the fields is named date. When I uploaded this to Qlik the dates read:

       

      42736

      42767

      42795

      ...

       

      I'm unsure what format this is but I am able to convert this into DD/MM/YYYY using the expression Date(num#(Date,'#')).

      This successfully changes the dates and they then read:

       

      01/01/2017

      01/02/2017

      01/03/2017

       

      But I want to have the dates read just 01/2017, 02/2017...

      Is it possible to make the date read in that way? If so, please let me know.

       

      Thanks in advance,

      Alison