3 Replies Latest reply: Dec 1, 2016 11:11 AM by Martha Parsons RSS

    Between dates Load file           Between dates Load file (Date > =(Today()-30) AND Date < = (Today()-8) )

    Martha Parsons

      Hello,

      I would like to grab data from today-8 and today-30. For example today being November 30th, I would like to grab data between 11/22/2016 and 10/31/2016. I tried below and It is pulling in the past 30 days. I can't have the past 7 days in this file because I will be doing a join with another dataset that has more detail for the last 7 days if that makes sense. The first dataset is like summary (the >=8 days to <= 30) and the second dataset will have the detail for the last 7 days. The reason why I am doing it this way is because just the last 7 days of detail is well into the millions of rows (just for 7 days). Where the summary is hundreds of thousands. I can't have 30 days of detail data.

       

      In my load file I have

       

      Where Date > =(Today()-30) AND Date < = (Today()-8)

       

      This is grabbing from SAS, which I have no control over the data.

       

      Thank you for the help

      Martha