1 Reply Latest reply: Oct 31, 2011 9:14 AM by Stefan Wühl RSS

    using specific dates in script?

    Chris Hopkins

      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