get previous month first date in sql code example Example: sql beginning of previous month SELECT DATEADD(d,1,EOMONTH(GETDATE(),-2))