Re: Recalculation of values

Make the field an unstored calculation.  That should make it update. 
Your problem then could be, if not stored, it cannot be indexed and 
hence has limited uses in relations.

HTH

Dave McQueen

> Can anybody help?
>
> I have a date field called deadline (when a piece of work is due). I also
> produce an internal progress report for meetings and would like to print out
> the deadline in green - if it's in the future - or red if it's late. So, I
> have defined a print deadline field:
>
> If ( Deadline < Get ( CurrentDate ) ; TextColor ( GetAsText ( Deadline ) ;
> RGB ( 190 ; 0 ; 0 ) ) ; TextColor ( GetAsText ( Deadline ) ; RGB ( 0 ; 153 ;
> 0 ) ) )
>
> This works when I add a new record but, once calculated, stays that way. How
> can I get it to recalculate based on today's date?
>
> Rob
> --
> Rob Tucker [Account Manager]
> Direction Marketing & Communications
> Web: www.direction123.com
>
>
> --
> To unsubscribe: send an email to 
> <fmpexperts-off-YhOVfwX2n+1GPrOSNmeGdnHfP1ztnLDb@xxxxxxxxxxxxxxxx>
> FMPexperts is hosted by Ironclad Networks <http://www.ironclad.net.au/>


--
............................................
David A. McQueen
LICHEN  Software
Barrie, ON, Canada
www.lichen-software.com
(705)720-9022