2 Replies Latest reply: Jun 30, 2017 4:37 PM by Justin Dallas RSS

    Can't get year or month from Date (qvd attached)

    Justin Dallas

      Hello Folks,

       

      I'm running into a peculiar situation, whereby my dates aren't being seen as date.  When I run the below script.

       

      BreadCrumbs:
      LOAD
          breadCrumb_Id,
          breadCrumbDateTime,
          YEAR(breadCrumbDateTime)
      FROM [lib://\RestrictedDataSet.qvd]
      (qvd);
      

       

      on the attached QVD, I get that the year is blank.

       

      Lyrically.PNG

       

      The only thing that I can think of is that the source for my QVD is a MySQL Community server, and Qlik doesn't know how to get metadata that says "this field is a date field" from the connection.

       

      Any help on why this date isn't being seen as a date would be greatly appreciated.