How can I create a variable that will contain the value of LASTWEEK, where lastweek is 7 days prior to today and is in the format of MM-DDD-YY (ie. 01-JAN-02)? The other question is how do I get the variable to correctly compute the date when LASTWEEK is the month prior to the current month? ie. LASTWEEK = TODAY - 7
26-DEC-01 = 02-JAN-02 - 7
26-DEC-01 = 02-JAN-02 - 7