z36h_returned_date of "20090931" (September 31, 2009)

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Article Type: General
Product: Aleph
Product Version: 20

Description:
I was wondering how Aleph came to write a z36h with a z36h_returned_date of "20090931". As you know, September only has 30 days, so this date is of course incorrect.

I am attaching an excel file that has the four records from the Z36h table that have this error.

Resolution:
You will note that in each case the date in the z36h_time is "20091031" and the z36h_returned_date is "20090931" (with a z36h_returned_hour for each of "1038").

It seems that these items were returned all at once, on 2009-10-31, I suspect with an "Override Date" of 2009-09-31 in GUI Circ.

Checking on our v20 server (rep_change 2432), I am unable to enter a date like "20090631" or "20090931" in the Override Date box. (I get "Invalid Date".) Please confirm that you also get "Invalid Date" for "20090931" in Override Date on your server.

I suggest that you check for such dates with the following SQL:

SQL> select z36h_returned_date from z36h where substr (z36h_returned_date,5,4) = '1131';
SQL> select z36h_returned_date from z36h where substr (z36h_returned_date,5,4) = '0931';
SQL> select z36h_returned_date from z36h where substr (z36h_returned_date,5,4) = '0631';
SQL> select z36h_returned_date from z36h where substr (z36h_returned_date,5,4) = '0431';

Checking other sites with high circulation, some for 10 years with Aleph, I get no hits.

I suggest that you periodically run this SQL to see if you are continuing to get cases like this.

Article last edited: 10/8/2013