I am receiving an error when trying to run a crystal report.  The error gives the "Failed To Retrieve Data" box, and then an error box "Conversion failed when trying to convert DateTime from character string".  I have tried several things that don't appear to work and this one has me stumped.

 

First of all, the field causing the issue is a datetime.  I have tried to convert it to a varchar.... didn't work.  I have tried to convert it to a datetime (have no idea why since it already is supposed to be) and that didn't work.  I thought it might be possible that the field had some data with invalid characters, so I wrote a case statement to only look for records where that field was a datetime.  That didn't work. 

 

I can get my report to run if I don't filter it with the criteria picker, but as soon as I enter a date in the criteria picker, I get this error.  Any ideas?

 

Thanks in advance!