|Subject:||Returning a previous date & value based on the current date|
|Posted by:||Hawkster (neil.perei…@nz.teletech.com)|
|Date:||23 Jan 2007|
Sorry not sure if the subject describes clearly what i am after.
I have a report which is setup as follows (with data going back a few
Week Beginning Value
I am after a formula that will return the date and value that is 52
weeks back from the current date.
This report will constantly be growing so it would need to be a rolling
Any help would be appreciated.