In CISPro 2024 the Local Date Columns feature has been added to Reports allowing UTC dates to be automatically converted to the clients local time zone.  However using this feature can sometimes cause the following error: Specified cast is not valid

What can cause this error?