Totes Posted November 29, 2007 Posted November 29, 2007 (edited) 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, 2007 by Guest
comment Posted November 29, 2007 Posted November 29, 2007 Case ( End Date ; "OK" ; Get (CurrentDate) ≥ Start_Date + 5 ; "Overdue!" )
Totes Posted November 29, 2007 Author Posted November 29, 2007 (edited) 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, 2007 by Guest
comment Posted November 29, 2007 Posted November 29, 2007 Because Case() returns the result for the FIRST test that evaluates as true.
Recommended Posts
This topic is 6264 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now