SQL Query showing date > ?

[CindyK]

When I view the SQL query in a report I get the following in the where clause:

WHERE
Product.`Product Type ID` < 5 AND
Orders.`Order Date` >= ? AND
Orders.`Order Date` < ?

The Selection formula (as shown in the expert) is as follows:
{Orders.Order Date} in DateTime (1997, 01, 01,00, 00, 00) to DateTime (1998, 12, 31,00, 00, 00) and
{Product.Product Type ID} < 5

The database is Access 97 via ODBC, using Crystal vs. 8

Why the question mark and not the real dates? Thanks in advance!

 

[kenhamady]

I have seen this on other platforms as well and I don't have a clear answer, but this might help. I am not sure if the &quot;?&quot; gets replaced by the date when the request is sent or not.

On a machine that has v8 installed I get what you have.
On a machine that has v8.5 installed I get literal dates, even when I run an older version of CR, like v7.

So this could be caused by an update to one of several files. Most likely the P2SODBC.dll, or possibly the ODBC Driver for MS Access. There is a download for an updated P2SODBC on the CD website, which might affect this. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com