Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try maybe
WHERE Date(Cal_Date) >= Date(makedate(2011,08,22) -56) and Date(Cal_Date) <= Date(makedate(2011,08,22));
Regards,
Stefan
try maybe
WHERE Date(Cal_Date) >= Date(makedate(2011,08,22) -56) and Date(Cal_Date) <= Date(makedate(2011,08,22));
Regards,
Stefan