Hello,

I am writing reports in Crystal 8.5, using the SQL designer against a SQL 2000 DB. I am currently having problems with a WHERE clause giving me date/time errors.

The clause looks like this... WHERE app_date between '{?StartDate}' and '{?EndDate}'

The parameter fields are set to string. The statement is giving me a conversion error.

Any help would be greatly appreciated. I think I need to use a cast or convert command, but I am not exactly sure.

Can you post the SQL statement exactly like it is being sent to SQL? Here's a couple of queries with BETWEEN statements that are working. In both examples the variable dates are in the same format as the datetime columns in the database. I hope this helps.

SELECT * FROM [Some Table] WHERE ('10/2/2005' BETWEEN StartDate AND EndDate)

SELECT * FROM [Some Table] WHERE (StartDate BETWEEN '10/1/2004' AND '12/5/2006')

Thanks,
Richard