9 Replies Latest reply: Apr 24, 2013 3:26 AM by Michel Drets RSS

    Importing a table using a date filter

      Hello all,

       

      I am trying to load data from an MS Access MDB file into Qlikview (The connection to the Access Database works fine). The problem is that I want to load only a subset of this data, based on today's date.

       

      In more detail: the data has a field that contains 'planned hours' (called Hours_Planning), and Ionly want to load the future planned hours, starting from 'today'. below is an excerpt of the code:

       

      SQL SELECT


           [Week] as [Week_Planning],
           [ProjectID] as [ProjectID_Planning],
           [PlanningID] as [PlanningID_Planning],
           [PersonnelID] as [EmployeeNumber_Planning],
           [Hours] as [Hours_Planning]


      FROM tblPlanning;


      The field [Week_Planning] should only be imported with dates greater than (or equal to) today.

       

      I already tried the following 3 where-statements, but to no avail.

       

      where DATE([Week_Planning], 'DD-MM-YYYY')>=DATE(01-01-2012, 'DD-MM-YYYY'); //we tried with a hardcoded startdate of January 1, as well as Today()
      where [Week_Planning] >='$Today()';
      where([Week_Planning])>=(Today());

       

      Thank you in advance!

       

      Michelle