Flag dates in a caculation..

[agaperrk]

I have two dates the current date today and an expiration of a certificate.... I need a calculation to give me a flag to say Renew, or expired..... Renew if the current date is less than 30 from the expiration and if it past the date in the field to say Expired.

Thanks in Advance.

Randy,

[LaRetta]

Hi Randy,

You can try this calculation (result is text) and be sure to set it to unstored:

Case (

ExpirationDate < Get ( CurrentDate ) ; "Expired" ;

ExpirationDate - 30 < Get ( CurrentDate ) ; "Renew"

)