During a recent SQL Server Reporting Services report writing project I needed to write some SQL to calculate the last Friday of the previous month for report parameters
Solution:
The SQL code to calculate the Last Friday of the Previous Month:
SELECT DateAdd(d,-1((datepart (dw, DateAdd (d,-1, DateAdd(mm, Datediff (m,0, GetDate()),0)))+)% 7), DateAdd (d, -1, DateAdd (d, 0, DateAdd (mm, Datediff(m, 0, Getdate()),0))))
If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us |