SQL get date of upcoming Friday

Question

How do I get the date of upcoming/next Friday using SQL?

If the current day is Friday, then return today's date.

Thanks so much, any tips and advice appreciated!

Please show what you have tried. – Thorsten Dittmar May 21 '14 at 07:52 — Thorsten Dittmar, May 21 '14 at 07:52

score 14 · Answer 1 · answered May 21 '14 at 07:55

14

declare @date datetime
select @date = GETDATE()

SET DATEFIRST 6
SELECT DATEADD(d, 7 - DATEPART(dw, @Date), @Date)

answered May 21 '14 at 07:55

David Brabant

41,623
16
83
111

Raj · Answer 2 · 2014-05-21T08:07:05.310

1

Try this

SET DATEFIRST 7
SELECT DATEADD(DAY,(CASE DATEPART(DW,GETDATE()) 
                    WHEN 7 THEN 6 
                    ELSE 6 - DATEPART(DW,GETDATE()) END),GETDATE());

edited May 21 '14 at 08:07

answered May 21 '14 at 07:55

Raj

10,653
2
45
52

this returns tomorrow when i execute it today but it should be the day after tomorrow ;) – DrCopyPaste May 21 '14 at 07:56
Really? For me it somehow returns `2014-05-23 13:27:49.760`, which happens to be day after tomorrow, a Friday – Raj May 21 '14 at 07:58
The result you get will depend on what `@@DATEFIRST` is. – GarethD May 21 '14 at 08:00
@GarethD ah thx for the tip that explains it with value 7 it works. – DrCopyPaste May 21 '14 at 08:08

SQL get date of upcoming Friday

2 Answers2