Does anyone have a workaround? Apparently the step that converts this field into the SQL view that Crystal uses through the OLE DB has an error in it. I can pull end date but not the start date. The error I get is i_SqlExec line 0 Conversion failed when converting date and/or time from character string. Error 1526.
I've tried converting it in a formula, but that doesn't work -- the field is not accessible to begin with.
And no, I can't do this report through ODBC -- I need to have the HRMS security in place when the report is added to the menu because of other information on the report.