weekly and monthly

Q. pls...

How can i make a weekly report? (the data must be shown in grid)

ex. i have a table with inputs dating 1/1/03 to 3/31/03

i wanted an output from the table on a weekly basis

the starting day of the week is monday to sunday

can i have some codes... thanks in advance :)


output: in grid

week1(monday to sunday)
1/3/03(:note 1/3/03 is wednesday ) - 1/5/03
TOTAL # of calls
96

week2(monday to sunday)
1/6/03 - 1/12/03
TOTAL # of calls
96

week3(monday to sunday)
1/13/03 - 1/19/03
TOTAL # of calls
79

week4(monday to sunday)
1/20/03 - 1/26/03
TOTAL # of calls
79

week5(monday to driday)
1/27/03 - 1/31/03
TOTAL # of calls
73

february *week1 starts again*
week1(saturday to sunday)
2/1/03 - 2/2/03
TOTAL # of calls
74

*bumps thread*

You can get the day of the week (weekday).
You can subtract that number from the current date to get Monday / Sunday.
You can add 7 days to the date (Format date +7D).

Try it and see.....

You can use dateadd and datediff to play with them dates.

Check them out