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:

       

      VastOpFunctie:

      Crosstable (Maand, OpFunctie)

      LOAD  PersoonsID,

          "42909",

          "42939",

          "42970",

          "43001",

          "43031",

          "43062",  

      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.