Jump to content
Sign in to follow this  
mmurdock

Overdue tasks

Recommended Posts

I have been trying for hours to get my calculation correct. Please someone give me some help to make this work. Here is my dilema....I want to show an overdue field when a file has not been returned by the specified due date. I can get it to show "Overdue" but I can not get the "Overdue" to go away once the file has been returned. Can someone please help....this is what I have done.....

I have four fields

(Overdue)= Calculation Field

RA Date Received

RA Due Date

RA Date Returned

Case (Get(CurrentDate) ≥ RA Due Date; "Overdue!";

IsEmpty(RA Date Received) and IsEmpty(RA Date Returned); ""; not IsEmpty(RA Date); "";)

I know I have something backwards, but I have tried every which way I can think of and can't get it to work correctly.

Share this post


Link to post
Share on other sites

How about:

Case ( Get(CurrentDate) > RA Due Date and not RA Date Returned ; "Overdue!" )

Share this post


Link to post
Share on other sites

Thank you sooooooooooo much!!! I was making it way more complicated than it needed to be.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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