Server Error on Bell Schedule Page : Aeries Software

Server Error on Bell Schedule Page Print

Modified on: Tue, Jun 10, 2025 at 8:45 AM

Server Error on Bell Schedule page - "Operator '-' is not defined for type 'DBNull' and type 'Date'.

NULL start or end time in Bell Schedule Times (BST) record

Update the missing time to the appropriate value or delete the BST record with the missing time

Use the Query Change form to add the correct time:

Use a CHANGE command query to add the correct time:

Example:

CHANGE BST T2 TO "07:55:00" IF T2 = NULL

Delete the record via SQL:

Example:

UPDATE BST 
SET DEL = 1 
WHER DEL = 0 AND (T1 IS NULL OR T2 IS NULL)

Did you find it helpful? Yes No

Server Error on Bell Schedule Page Print