convert a date into the date of the friday in the present week, ie the week ending

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Kenneth Wilhelmsson SSC-Dedicated Points: 30043 More actions · Answer 1

Here's one way to do it. Adjust datefirst and/or the offset in dateadd() functions accordingly for what start-end days you want.

-- The example shows how to find out on which dates a week

-- starts and ends, given an arbitrary date.

-- Start of weeks are on Mondays, and ends on Fridays

set datefirst 1 -- Make sure week starts on a monday

declare @today datetime

set @today = '2004-03-04'

select @today as 'today',

dateadd(day, 1 - datepart(weekday, @today), @today) as 'first_weekday',

dateadd(day, 5 - datepart(weekday, @today), @today) as 'last_weekday' -- friday

today first_weekday last_weekday

------------------------ ------------------------ ------------------------

2004-03-04 00:00:00.000 2004-03-01 00:00:00.000 2004-03-05 00:00:00.000

/Kenneth

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 2

-- Friday

DECLARE @Date DATETIME

SET @Date = GETDATE()

SELECT CONVERT(VARCHAR(10), DATEADD(DAY, 6 - DATEPART(WEEKDAY, @Date), @Date), 101)

Good Hunting!