Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Current week a year ago

Status
Not open for further replies.

lewes

Technical User
Apr 7, 2008
14
GB
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
 
You have to clarify your convention for First Week of Year and identify the first day of your week (Sunday)? Please look of First Week of Year constants in the CR help section to see what the options are and to pick which matches yours.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top