Weekday calculations

Soon to come…

SELECT (DATEPART(DAYOFYEAR, DATEDIFF(DAY, ‘00010101’, GETDATE()) / 7 * 7 + 3) + 6) / 7

Leave a Reply