T-Sql Help

[vizagpower]

i need to get my dates dynamic , in the sense every time i run the code it should fetch past 7months data , say if i run the code in june it should get data from 2013/11/01 and 2014/05/31 , as of now im hardcoding these values in my where clause , any idea on how , next month if i run it should get data from 2013/12/01 till 2014/06/30

thanks in advance

 

[mtkr]

any date colm in tht tbl??

if yes apply where datecolum between getdt and getdate-7months...
convert dates to varchar

[cherlapalli_jailer]

i need to get my dates dynamic , in the sense every time i run the code it should fetch past 7months data , say if i run the code in june it should get data from 2013/11/01 and 2014/05/31 , as of now im hardcoding these values in my where clause , any idea on how , next month if i run it should get data from 2013/12/01 till 2014/06/30

thanks in advance

why hard coding 

 

u can  getdate() and getdate() - 7 months

[cherlapalli_jailer]

any date colm in tht tbl??

if yes apply where datecolum between getdt and getdate-7months...
convert dates to varchar

repost

[ghazni]

USE datediff put the getdate()

[mtkr]

repost

ekkada postdd!!

[papacha]

Declare Variables and call them

 

DECLARE @Month INT

DECLARE @year INT
DECLARE @dtnow DATETIME

SET @dtnow = GETDATE()

SELECT @Month = MONTH(DATEADD(MONTH,-6, @dtnow ))

 

and use those in where clause

[vizagpower]

any date colm in tht tbl??

if yes apply where datecolum between getdt and getdate-7months...
convert dates to varchar

will that give me from begining of the month ? like 2013/11/01  

[Reddy0430]

will that give me from begining of the month ? like 2013/11/01  

 

WHERE MyDate < DATEADD(month, -2, GETDATE())

 

 

in place of two place 7 months

 

reference: http://stackoverflow.com/questions/5425627/sql-query-for-todays-date-minus-two-months (for understanding)

[mtkr]

will that give me from begining of the month ? like 2013/11/01

use

where datecolm between dateadd(month,0,getdate())-7,0) and dateadd(month,datediff(month,-1,getdate())-1,-1)

convrt dates to varchar..