Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6264 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted (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 by Guest
Posted (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 by Guest

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.