Given a date, how do I find the beginning and end of that week?
Assuming you have a standard work week, let's say you have a variable that represents a date, and you want to find out the first and last day of that week (the preceding Sunday, and the upcoming Saturday).
If you don't have a standard week (e.g. day 1 = Monday), you could just adjust the numbers used for the calculations (1 and 7).
If you need to find the start of the *business* week, you can add 1 to the first result and subtract one from the second, for example:
However, your calculations might not be so simple, because this obviously doesn't take into account holidays and other interruptions in a typical work week. See Article #2453 for a demonstration of the use of a calendar table to help count business days.
Related ArticlesCan I get millisecond accuracy in ASP?
Can I make VBScript format dates for me?
Could I get a little help with dates?
Given two dates, how do I determine an age?
How do I calculate dates, such as the first day of the month?
How do I convert a DATEDIFF to days, hours, and minutes?
How do I convert a timespan, in seconds, to HH:MM:SS?
How do I convert local time to UTC (GMT) time?
How do I count the number of business days between two dates?
How do I delimit/format dates for database entry?
How do I determine the number of seconds since 1/1/1970?
How do I display time in military format?
How do I implement a calendar / datepicker in ASP?
How do I select time only from a DATETIME column?
Why do I have problems inserting NOW() into a database?