calculation date range

[Jabert73]

I want to test a due date, and display a message depending on:
Due Now - (the date is 29 days or less away, or has past the due date - Statur(CurrentDate))
Due Soon - (the Due Date is 30-90 days away)
If the date is 91 days or more, no message

I have come up with a solution that almost works, but it requires several calculations. Is there a quick way to caclulate a date range?

Mac OS 10.3.9 - G4 dual - FMP 6

Thanks,

John

 

[Schlogg]

Wonder why this hasn't been answered? Hope I'm not missing something!

Case(DueDate > Status(CurrentDate)+ 90; "";
DueDate > Status(CurrentDate)+ 29; "Due Soon";
DueDate >= Status(CurrentDate); ""



Cheers,
Paul J.