I have a simple query with a date that is converted (because I don't want hh:mm:ss).
The query runs prefectly, for me, in SS Management Studio and also from Crystal and Crystal Report Viewier.
However, some users can run the report without any problems and others receive the following error message:
"Crystal Report Viewer
Failed to open a rowset.
Details: ADO Error Code: 0x80040e07
Source: Microsoft OLE DB Provider for SQL Server
Description: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
SQL State: 22007
Native Error: 242
I have used the ISDATE() function to ensure all dates returned are valid and no problems there.
If I remove the convert from the query it is fine for everybody to use.
I have checked the Language/Country setting and other settings on the users machines who get the error thrown and have checked d/b permissions but cannot find anything wrong/different to mine.
I have also spent ages on the Internet trying to find a solution, but no joy.
Please help me!