Expiration Date Flag

[agaperrk]

I have a field I want to be a flag for a expiring date.

CurrentDate < Datefield -30;"expiring";

CurrentDate > Datefield + 1 ;"expired";""

It will just show the text I want to put in it. I need to tweek this a little

Thanks in advance.

[mr_vodka]

Case ( Get ( CurrentDate ) >= YourDatefield; "Expired";

       Get ( CurrentDate ) +30 > YourDatefield; "Expiring"

     )

Edited May 21, 2009 by Guest