I have three fields:

Start Date

Overdue

End Date

What I currently have:

If(Get( CurrentDate ) ≥ Start_Date + 5 ; " Overdue!" )

No problem it works and puts Overdue in the "Overdue" field…but what I need to do now is:

Enter a date into the “End Date” field and for the “Overdue” field to then show the text as “OK”.

I have tried a Case statement but cant make that work either?

Can someone help please?

Thank,

James

Edited November 29, 200718 yr by Guest

Case (

End Date ; "OK" ;

Get (CurrentDate) ≥ Start_Date + 5 ; "Overdue!"

)

Comment,

Once again thanks...I should have just called you first :

could you tell me something?

This is what I was working with:

Case ( Get (CurrentDate) ≥ Start_Date + 5 ; "Overdue!" ; not IsEmpty ( End_Date ) ; "OK" )

It is almost what you gave me only reversed...and of course mine would not work.

Why would mine not work?

Thanks again (I spent all day yesterday pounding on this one to no avail).

James

Edited November 29, 200718 yr by Guest

Because Case() returns the result for the FIRST test that evaluates as true.