using specific dates in script?

[hopkinsc]

Hi, i currently have a 10 week transaction application which looks at a rolling 10 weeks.

The expression i have used in my script is :

CapperCalender:

    LOAD Cal_Year,

         Cal_Period,

        Cal_Week,

         Cal_YearDay,

         Cal_Date AS TradingDate,

         [Cal_Year-Period]

    FROM $(cFileName) (qvd) WHERE Date(Cal_Date) >= Date(Today() -70);

This will only load in data dated todays date going back 70 days.

I want it to show from the date 22/08/11 going back 56 days.

Can anyne help?

Thanks

[swuehl · Accepted solution]

try maybe

WHERE Date(Cal_Date) >= Date(makedate(2011,08,22) -56) and Date(Cal_Date) <= Date(makedate(2011,08,22));

Regards,

Stefan