Immunization page gives an error "Conversion from type 'DBNull' to Type 'Date' is not valid" : Aeries Software

Immunization page gives an error "Conversion from type 'DBNull' to Type 'Date' is not valid" Print

Modified on: Sat, Aug 10, 2024 at 6:16 PM

When attempting to open the Immunization page, it gives a YSOD error: Conversion from type 'DBNull' to Type 'Date' is not valid.

Cause

This error occurs on the Immunization page when there is at least one student in the database that is missing a birthdate (STU.BD).

Add a birthdate for any student with a blank Birthdate (STU.BD) value

Running this query will identify any blank birthdates LIST STU ID NM BD IF BD = NULL

Define Required Fields page can be used to make the Birthdate (STU.BD) field required.

Did you find it helpful? Yes No

Immunization page gives an error "Conversion from type 'DBNull' to Type 'Date' is not valid" Print