Getting First Weekday of Month in T-SQL

IF DATEPART(day, GETDATE()) <= 7 AND DATENAME(weekday,GETDATE()) = 'Monday'

  • DATEPART checks to see if the given date is in the first week of the month
  • DATENAME checks to see if that date is a Monday