Click here to Skip to main content
14,695,504 members
Please Sign up or sign in to vote.
3.00/5 (2 votes)
See more:
I am facing issue in calculating past 5 week data based on current date (excluding currrent week) For e.g: Suppose we are in 40th week of this year, I need to get the sum of all the transactions for the previous 5 weeks (39, 38, 37, 36 & 35).

Currently calculating based on the calendar day but as Calendar day is giving the granular level of data, inorder to increase the performance I need to use the calendar week (sample data like (2012/40).

Is there a way to do this?
Posted
Comments
Milan Mathew 17-Oct-12 4:11am
   
looking for a solution based on the CalendarWeek

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900