Info-lake
Knowledge sharing....
April 30, 2012
Last and First Day of the previous months
--LAST DATE OF PREVIOUS MONTH
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0))
--GET FIRST DATE OF PREVIOUS 3 MONTHS
SELECT @STARTDATE = DATEADD(DD,-(DAY(DATEADD(MM,1, GETDATE()))-1),DATEADD(MM,- 3, GETDATE()))
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment