12 Replies Latest reply: Dec 1, 2017 7:12 AM by jukah doanart RSS

    Dates after year 2079 do not work

    jukah doanart

      Hi all,

       

      I have weird problem with my dates. When I use this script combined with autoCalendar I get the date fields derived as expected:

       

      Data:
      Load
      Document,
      Date(Start_Date,'MM.DD.YYYY') AS Start_Date,
      Date(End_Date,'MM.DD.YYYY') AS End_Date
      Inline
      [
      Document,Start_Date,End_Date
      A,05.10.2015,31.12.2055
      B,12.10.2016,31.12.2079
      C,06.06.2017,31.12.2079
      ]
      (Delimiter is ',');
      
      
      

       

      A.PNG

       

      However, if a date is in year 2080 or later, Qlik Sense does not generate the date field:

       

      Data:
      Load
      Document,
      Date(Start_Date,'MM.DD.YYYY') AS Start_Date,
      Date(End_Date,'MM.DD.YYYY') AS End_Date
      Inline
      [
      Document,Start_Date,End_Date
      A,05.10.2015,31.12.2055
      B,12.10.2016,31.12.2079
      C,06.06.2017,31.12.2080
      ]
      (Delimiter is ',');
      
      
      

       

      B.PNG

       

      Any idea what is going on here? Thanks!