Group,
On my form I have this text box that displays "Overdue" when this criteria is 
met...otherwise it's just blank....see expression below:
 
=IIf((IsNull([LastRating]) Or Date()-[LastRating]>180) And 
Date()-[StartDate]>180 And [nonfunded]=No,"Overdue")
 
The above works fine.  However, my question is how do I also display the amount 
of days this record is overdue?  For example, I would like it to say "Overdue 
130 days".  I know I should use the DateDiff function, but I am not sure how to 
incorporate it into this expression.
 
Any help is appreciated!
 
TIA,
Izzy


[Non-text portions of this message have been removed]

Reply via email to