2 Replies Latest reply: Aug 17, 2016 8:56 AM by Bebee Pastino RSS

    Date expressions in Data Load Editor

    Bebee Pastino

       

      Hello,

       

      I’m working in the Data Load Editor in QLIK Sense.  I want limit my data by reviewing two dates.

      Booked_Date and Snapshot_Date.  The Snapshot_Date is always the first day of the Month

      The Booked_Date needs to be 3 months prior to the Snapshot_Date.  I’m thinking to subtract the Number of Months between the two dates.  If they equal to 3 get the data. 

       

      I can’t figure out the Syntax to do this.  Below are examples of what I’m working with

       

      Booked_Date

      Snapshot_Date

      Capture

      04/05/2016

      07/01/2016

      Yes

      04/15/2016

      05/01/2016

      No

      12/15/2015

      03/01/2016

      Yes

      12/15/2015

      12/01/2015

      No

       

       

      Thank you in advance

       

      Bee