Issue: When trying to access a student's Language Assessment page, the user experiences a YSOD with the following error message:


"Conversion from string "" to type 'Date' is not valid"



Cause

The student's Home Language Survey data is missing a date in the Survey Completed Date (LAC.HLD) field. If LAC.HLD is missing, a YSOD will occur.



Resolution

Use the Query Change button to populate the Survey Completed Date (LAC.HLD) field: 

  • Determine the date the Survey was completed by the parent. 
    • Either from a hard-copy of the Home Language Survey, or if Online Enrollment is used, the user can see the date the record was added to Aeries, on the Student Data 2 tab.


  • Run this LIST Query changing the X's to the student's ID:

            LIST LAC ID L1 L3 L2 L4 HLD HLH IF ID = XXXXXXX


  • After running the Query, Click on the Change button on the Query menu:


  • On the Change popup page, populate a date in the Home Language Survey Date field. Then click on the orange LAC to lock all fields (there is no Save button on the page).




Navigate back to the student's LAC page and it should now be accessible.