SQL(Quries with automatic date ranges)

-- [THIS DATES LOGIC HELP YOU TO GET THE RESULTS WITH DATES WITHOUT ENTERING DATES MANUALLY]

--{THIS QUERY GET THE RECORDS ENTERED IN THE CURRENT MONTH TILL TO DATE}

SELECT *

FROM   <Table_Name>

WHERE  <Date_Column> BETWEEN Dateadd(MONTH, Datediff(MONTH, 0, Getdate()), 0) AND Getdate()

--IF CURRENT MONTH IS = 'January'

--IF CURRENT DAY IS = '18'

--RESULT: 'Get The result from 1st day of January Till Today(Now)'

--{THIS QUERY GET THE RECORDS ENTERED IN PREVIOUS WHOLE MONTH }
SELECT *

FROM   <Table_Name>

WHERE  <Date_Column> BETWEEN Dateadd(MONTH, Datediff(MONTH, 0, Getdate()) - 1, 0) AND Dateadd(MONTH, Datediff(MONTH, -1, Getdate()) - 1, -.00001)

--IF CURRENT MONTH IS = 'January'

--IF CURRENT DAY IS = '18'

--IF CURRENT YEAR IS = '2016'

--RESULT: 'Get The result from 1st day of Previous Month Till Last Day Of Previous Month

--         in this case it will get the result of December of last year'