user447

Help for calculation

Discussion created by user447 on Sep 21, 2017
Latest reply on Sep 24, 2017 by bigtom

Need help to figure out number of days over due for a library book.  I have  3 dates fields:   Check Out Date, Due Date, and Check In Date.  If Check in is before Due Date, then days overdue = 0.  If check in date is after date due, then days overdue = Check In minus Due Date.  But if Check In Date is empty, then days overdue should be Due Date minus today's date.  Right?  Is the order important?  I Can't seem to get the calculation correct.  Appreciate any help.  Thanks.

 

 

 

Case(

Check In Date ≤  Due Date;

"";

 

IsEmpty ( Check In Date );

Due Date-Get ( CurrentDate );

 

Check In Date  > Due Date;

Check In Date-Due Date;

 

"")

Outcomes