I am using SQL Server 2014 and I need to add a line of code to my SQL query that will filter the data extracted only to those records where the
greater than or equal to
1st day of the current month
WHERE StayDate >= '1st Day of Current Month'
EOMONTH to get the first day of current month
WHERE StayDate >= Dateadd(dd, 1, Eomonth(Getdate(), -1))