The Error reads:
Failed to retrieve data from the database.
Details: ADO Error Code: 0x80040e07
Source: Microsoft OLE DB Provider for SQL Server
Description: The conversion of char data type to smalldatetime data
type resulted in an out-of-range smalldatetime value.
SQL State: 22007
The report was receiving this same error last week and so I went through the data in the database until I found the invalid date value and had the customer correct it. When the SQL ran in SQL Server Mgt Studio, I expected it to run in Crystal too, but it failed again. Is there any reason that Crystal would give this error when I can run the command in SQL?
thanks
michele