Hi all,

I have this SQL statement.I create it by the View Designer.Now the question is why the View Designer puts automatically quotation marks in the first AND statement ?. I need this field to campare range dates...

SELECT Mytable.date, Mytable.descrip, SUM(Mytable.amount), Mytable.quotas,;
Mytable.amount;
FROM Mydatabase!Mytable;
WHERE Mytable.date BETWEEN ?dDateFrom AND ?dDateTo;
OR (Mytable.plan = .T.;
AND Mytable.date <= "dDateTo";
AND ALLT(Mytable.quotas) = "0");
GROUP BY Mytable.num_oper;
ORDER BY Mytable.date

TIA