The way to get the beginning of the month (b/c there is no SQL function) is to subtract one month from the date, get the EOMONTH of that date, and then add 1 day. declare @SignupDate date = '7/28 ...