computergeek
Programmer
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,
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,