Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Art is meant to disturb, science reassures
 
Braque
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

28
July

How Do I Calculate the 1st Monday of the Previous Month using SQL

During a recent SQL Server Reporting Services report writing project I needed to write some SQL to calculate the 1st Monday of the previous month for report parameters

Solution:

The SQL code to calculate the 1st Monday of the Previous Month:

Select DateAdd(d, (7-((datepart(dw, DateAdd(d,0, DateAdd(mm, DateDiff(m, 0,GetDate())-1))) + (7-2))%7, 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

MAKE A COMMENT

Name *

Email Address *

Comment *