4Site
Support Request System
View Patch #60.001.070
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
03833 -
Time of Midnight does not appear in meter reading grid
Symptoms:
When entering meter readings via the grid input(on a list or equipment), if you change the time portion of the Reading Date field to be midnight and leave the *row*, then return to the row and enter a reading value, the Reading Date field is missing the midnight time.
Solution:
Fixed time portion dropping off of display when it is equal to midnight when returning to a row and entering a reading value: If the time portion is midnight, the Microsoft Recordset control will only return the date portion, for some reason. So, if you enter "03/10/11 12:00:01 AM", the Recordset returns "03/10/11 12:00:01 AM" But if you enter "03/10/11 12:00:00 AM", the Recordset returns "03/10/11" This messes up the cell display as it will not match the format of all the other non-midnight values. So, to fix it we have to format the Recordset output manually *again* to be in the full, proper format with the time included. Note that this was a display-only issue as a blank time is interpreted as midnight by SQL server. The meter reading is saved just fine.
Browse Patches
Find a Patch
Return to Request System Menu
