Week Formula

[strom99]

Hi

Have the following field cut_date and I need to include another field that will tell me which week (date) it occured. So if it the cut_date was 09/17/03 I would need another column to tell me that it occured during the week of 09/15/03.

Thanks much!

 

[SQLBill]

Try this:

DECLARE @querydate DATETIME
SET @querydate = '2003-09-17'
SELECT DATEADD(DAY,(DATEPART(DW,@querydate))-(@@DATEFIRST)), @querydate)

If it doesn't return the proper day, do this
SELECT @@DATEFIRST

The result should be 1 if it's set to show MONDAY as the first day of the week.

-SQLBill