GetDate( ) one year old

[irate]

I'm looking for an easy way put SELECT all records that are less than a year old.
Ive got something like this at the moment but i cant seem to concatenate them together.

SELECT DATEPART(yy,GETDATE() - 1 )
SELECT DATEPART(mm,GETDATE())
SELECT DATEPART(dd,GETDATE())

Does anyone know how to stick them together or of a way to get todays date minus 6 months in a less complicated way?

 

[Cagliostro]

select* from xxx where x= dateadd(yy,getdate(),-1) John Fill
ivfmd@mail.md

 

[ScottAW]

Almost -- syntax is DateAdd(yy,-1,GetDate())

 

[irate]

Fanx guys, thats great.

 

[irate]

Quick Q:

if i do DateAdd(mm,-6,GetDate()) on december ill get june,
but if its may then what happens? does it take one of the year automatically???

 

[ScottAW]

Yes. Dateadd will not confine you to the current year. It will go back 6, 16, 26 months, whatever.

 

[Cagliostro]

Yes John Fill
ivfmd@mail.md

 

[irate]

thanx again