Return Receipts displaying incorrect due date

Description

Earlier this week, the library accidentally erased all of their hours and exceptions, so any items they checked out came back with a due date of 01/20/2038.

Now their hours and exceptions have been fixed, but all of the return receipts that are generated for items that were checked out during that time are still showing 01/20/2038 as the due date. 

Below is the most recent return receipt. The item was checked out on 09/10/18 12:40 PM when the hours were missing and received the 01/20/38 due date. It was then returned on 09/11/18 06:01 PM. The same item was checked out again 09/12/18 10:05 AM and received a due date of 09/12/18. It was returned 09/12/18 10:06 AM and the circ log says the due date was supposed to print as 09/12/18, but as you can see below the return receipt still used the 01/20/2038 due date.

    Call No:: Mac charger 
    Barcode:: 31122054993303 
    Due Date:: 01/20/2038 
    Returned Date:: 09/11/2018 

Resolution

The "Due Date" which displays on the receipt is coming from the z36h loan history table.  The following SQL was used to determine how many cases there were:

SQL> select z36h_due_date from z36h where z36h_due_date like '2038%'; 

And the following to correct them:

SQL> update z36h set z36h_due_date = '20180900' where z36h_due_date like '2038%'; 

Note:  You could change them to an actual day (rather than "0900"), if you know what's correct.

• Article last edited: 25-Sep-2018