SELECT DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0) AS FirstDate
SELECT DATEADD(DAY,DATEPART(DAY,GETDATE()),GETDATE())
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)