date plus 3

[keydash]

I am stumped over a probably simple calculation.

How do I structure a formula to show if the Current Date is equal to or larger than the date of Modification plus 3 years?

I have calculated the length of time since modification, but how do I add 3 years and compare to the current date?

Thanks...

[RussBaker]

Case(

Status(CurrentDate) >= Date(Month(ModificationDate), Day(ModificationDate),Year(ModificationDate) + 3),

"Out of Date",

"Still in Date"

)

Or, you could get fancy and have:

Case(

Status(CurrentDate) > Date(Month(ModificationDate), Day(ModificationDate),Year(ModificationDate) + 3),"Out of Date",

Status(CurrentDate) = Date(Month(ModificationDate), Day(ModificationDate),Year(ModificationDate) + 3),"Expires Today",

Status(CurrentDate) >= Date(Month(ModificationDate), Day(ModificationDate) - 7,Year(ModificationDate) + 3),"In Date Expire Within 1 Week",

Status(CurrentDate) >= Date(Month(ModificationDate) - 3, Day(ModificationDate),Year(ModificationDate) + 3),"In Date : Expire Within 3 Months",

Status(CurrentDate) >= Date(Month(ModificationDate) - 6, Day(ModificationDate),Year(ModificationDate) + 3),"In Date : Expire Within 6 Months",

"Still in Date"

)

[keydash]

Russ

Thanks so much for both examples. These were exactly what I needed.

Al