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 :
Cal_Date AS TradingDate,
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?