using specific dates in script?

hopkinsc — Mon, 31 Oct 2011 13:02:52 GMT

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 — Mon, 31 Oct 2011 13:14:57 GMT

try maybe

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

Regards,

Stefan

topic using specific dates in script? in QlikView