How to display an overdue(date) record?

[summer00]

i have payment table here with payment_date field(shows the last payment) in it...now what i wanna do is to display the records that the current date minus payment_date is greater than 2 months...

for example:

today : 03/15/2004
all the records before 01/15/2004 will be displayed....

thx a lot

[skhanal]

Use DATEDIFF function to find the difference between current date and last payment date.

[MAK]

select * from sysobjects where crdate<=(getdate()-60)