5 Replies Latest reply: Oct 23, 2017 5:38 PM by Wilfred Geerlings RSS

    Date conversion

    Wilfred Geerlings

      Dear All,


      As starter cannot get de date conversion into the tabel:



      Crosstable (Maand, OpFunctie)

      LOAD  PersoonsID,







      FROM [lib://qlikid_wilfredsj/test.xlsx]

      (ooxml, embedded labels, table is Blad1)


      Want I want is convert  "42909" to month, Year

      I figure out i should be Date(Maand,'MMM YYYY') as Maand but where to place it in the script?


      So that the "maand" column holds  march 2017 in stead of 42909"  ...


      I would really appreciate is someone can provide me the right script.