Monday, March 22

Qry to get first and last date of months

SELECT DATEADD(dd, -DAY(DATEADD(month, 0, getDate())), DateADD(month, 0, getDate())+1)
SELECT DATEADD(dd, -DAY(DATEADD(month, 0, getDate())), DateADD(month, 0, getDate()))

No comments: