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.





Check In Date ≤  Due Date;



IsEmpty ( Check In Date );

Due Date-Get ( CurrentDate );


Check In Date  > Due Date;

Check In Date-Due Date;