No date blank Continued...

[Snookless]

Hello all,
Taking the current date and subtracting another date field, if the result is negative I would like to see the word "Expired", is this possible and how?
Thank you,
Snookless

 

[synapsevampire]

Create a formula containing something like:

If currentdate - table.datefield} < 0 then
&quot;Expired&quot;
else
totext(currentdate - table.datefield}) + &quot;days difference&quot;

-k

 

[pgtek]

Yes
Create formula
@Expire

if
totext({currentdate} - {field_date})= &quot;0&quot;
then &quot;Expired&quot;
cheers

pgtek