Due Date -

Hi

Please help me with a calculated field

Based on the current day:

If the recommendation (REC DATE)) due date is after the current current day  - thenn state "still have time"

If the recommendation(REC DATE) due date is before the current date  -- need to state "date has passed" -    

I need this calculated field only to be applicable for only for recommendations (REC)  with status "c"

thanks

David.