Hi
Based on the curent date at the time of running the report. I would like to calculate the date for the Monday of the equivalent week to the current week a year ago.
For example using Thursday 18th August 2011, I would want it come up with Monday 16th August 2010.
Thanks for any help
Based on the curent date at the time of running the report. I would like to calculate the date for the Monday of the equivalent week to the current week a year ago.
For example using Thursday 18th August 2011, I would want it come up with Monday 16th August 2010.
Thanks for any help