Date Selection Formula

[computergeek]

Hello,

Crystal 8, Oracle 8, Date Column Type=Date

Report Menu>edit selection Formula>Record
{TableA.SAMPLE_DATE} = CurrentDate and {TableA.MATERIAL_NAME} like '32-0-0 UAN%'

Why does 'Show SQL Query' Show:
SELECT colA, colB, Sample_date, Material_name, colc
FROM
TableA
WHERE
TableA."SAMPLE_DATE" >= ? AND
TableA."SAMPLE_DATE" < ? AND
TableA."MATERIAL_NAME" LIKE '32-0-0 UAN%'

What is it doing with the dates? I thought I requested for the date to be equal to today's date?

Please advise... thanks,

 

[computergeek]

Hi,

Sorry nevermind. I changed the wildcard % (Oracle wildcard) to * and everything is fine now...