2 Replies Latest reply on Sep 22, 2019 4:30 AM by Zach Leber

    Weekly date data failed to be recognized as date type

    Ju Ho Lee

      Hi, in my dataset, the date variable is stated as weekly based, and they are failed to recognized as date when I change the type as date.

       

       

      The dataset looks like

      201901,201902, 201903, 201904,.... 201936, and so on.

       

       

      I tried them with the change as Week 1, Week 2... but it still cannot be recognized in the system.

      I would like to use it as date type to draw line graph.

       

       

      Can anyone know what I should do to use it as a date type?

       

       

       

       

      Thanks in adanve!