Date Formula - Should I use the Absolute (ABS) syntax?

[acr1]

Hi Team

I have a formula below that works as I need to find dates greater than one year...but I also need it to calculate when the PURCDATE is greater than the ACQDATE as well....
as i have some PURCDATE fields (1988 - later) and some ACQDATE fields (1975 - earlier)

Should I use ABS?

Current formula is as follows:

{COMPEQ.PURCDATE}<>{ASSVALUE.ACQDATE} and
(({COMPEQ.PURCDATE} + 366)>{ASSVALUE.ACQDATE}) and
IsNull({COMPEQ.EXPDATE}) = True

Any help a.s.a.p would be greatly appreciated..

TIA
Angus

 

[rchandr3]

Use DateDiff

As simple as that



Cheers,

Ravi

 

[acr1]

Hi Ravi

Thanks for your reply...but looking at the numerable ways to use DateDiff an example if possible would help..

TIA
Angus