weekly report

[cmw]

How will do weekly report per month?
eg if month="March" then result is week1=01/03/2008 to 07/03/2008, week2= 08/03/2008 to 14/03/2008 ,week3=15/03/2008 to 21/03/2008,week4=22/03/2008 to 31/03/2008

 

[ST4RCUTTER]

In the query that is the data source for the report, you can calculate the week number by using the DatePart function.

Weeknum: DatePart("ww",[Date],2,1)

Then you can filter or group based on the week number. In the example above the last two arguments (2,1) are optional and used to determine which day starts the week and when week 1 starts. As you probably know, there are multiple ways to designate the first week of a year. HTH



ST4R,

 

[cmw]

Thanks ST4RCUTTER, I want only week number in given month.
eg if month="March" then result is week1=01/03/2008 to 07/03/2008, week2= 08/03/2008 to 14/03/2008 ,week3=15/03/2008 to 21/03/2008,week4=22/03/2008 to 31/03/2008