Date Difference

Database

Date Difference

Hi,

I want to find difference between 2 date fields and only select it if the difference is greater than 3 years

Example
Dt1 = 01/01/2003
Dt2 = 01/01/2007

Difference is greater than 3 years

Dt1 = 02/01/2004
Dt2 = 01/01/2007

Difference is less than 3 years don't count it

Thanks much in advance.
1 REPLY

Re: Date Difference

WHERE ADD_MONTHS(DT1, 36) < DT2
;