Given a date, how to find the beginning date and ending date of that week

[Matt]

My ASPX page has a calendar, and when the user click any date on the
calendar, it will display the report during that week.

My question is when the program query database, I need to know the beginning
date and ending date of that week.

Any ideas??

[Matthew Speed]

On Sat, 8 Nov 2003 11:59:53 -0800, "Matt" <ma*******@hotmail.com>
wrote:

My ASPX page has a calendar, and when the user click any date on the
calendar, it will display the report during that week.

My question is when the program query database, I need to know the beginning
date and ending date of that week.

Any ideas??

The datepart function will tell you the current day of the week, eg
Sunday 0, Monday 1, etc. Use the value from that to add to or
subtract from to get Sunday and Saturday.