display the records not within 60 days

[aman]

Hi guys

I have a table that stores customer details. There are two date fields Date1 and Date2.

I want to find the difference between date 1 and date 2 and display the records whose difference is greater than 60 days.

Can anyone please help me in writing the sql query for this purpose.

I hope you understand my problem.

Thanks

 

[JANR]

Use the DateDiff function and set the critera: >60

ex:

Filtered Customer: Datediff("d", [date1], [Date2])

criteria:

>60

JR

 

[aman]

Thanks a lot JANR for your help.