I have a db table full of events and their dates, etc. I'm displaying them a week at a time. So, for example, when I come to the page this week's events (from sunday to saturday) are displayed. I use a week integer which defaults to
week = cInt(DatePart("ww", Date))
and then if they go to "next week" or "previous week" the variable is passed through a querystring. All that is working fine. The tough part is what I want to do next-- using my week variable (for example, today it's 51), I want to find out the starting and ending dates of this week (so the result would be dec 16 and dec 22).
how should I do this?? ideas?