Overdue Item that aren’t yet overdue

Currently we are using KOHA version 3.10. Previous version used is 3.06.

Problem reported :
Tarikh hari ini jadi "Over Due". Sepatutnya tarikh selepas itu iaitu esok.
 
Cause
 
 
 
Solution
I'm not sure whether this is the right solution. The ideas are :

1. Update data type for field date_due from date to datetime
2. Update records for date_due >= today, set the date as it is plus time 23:59 (Just to rectify existing records with 00:00 time. Dont bother about record with date_due < today, they are no doubt overdue.)
3. Done

As for now, it works well. The following incoming record will automatically record date_due in datetime format.

Alhamdulillah. Case settle! Yeayy... lompat bintang.... ;P