Compare dates minus 2 months

[Chuck712]

I am very new to SQL. I have a situation that calls for me to calculate renewing memberships. The criteria is that the membership join date must be greater than 2 months from the pay date. This is considered a renewal. Once I am able to get the correct results, I will need to make this available on an ongoing basis, so I don't want any hard coded dates.
I admit I am over my head on this one.

 

[DotNetGnat]

look into DateAdd() and DateDiff() function in BOL...

-DNG

 

[SQLDenis]

Define 2 months?
both of these with the same dates will return 32 days but 2 months, is this 2 months?

--2 months
declare @d datetime
select @d ='2005-12-31 00:00:00.000'
declare @d2 datetime
select @d2 ='2006-02-01 00:00:00.000'
select  datediff(m,@d,@d2)

--32 days
declare @d datetime
select @d ='2005-12-31 00:00:00.000'
declare @d2 datetime
select @d2 ='2006-02-01 00:00:00.000'
select  datediff(dd,@d,@d2)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Chuck712]

Thank you. 60 days would be the more accurate way to compute this.

 

[SQLDenis]

then
where datediff(dd,@d,@d2) > 60
of course @d and @d2 would be the names of your fields

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/