[DUG-DB]: Paradox - Date

[John Christenhusz]

G'day all,

Can anybody tell me what the syntax is for the current date in a SQL for
Paradox?

Thus something like:

select *
from TABLE
where FieldDate <= NOW



However, NOW & DATE don't seem to work! What should it be?


Thanks,

John Christenhusz

winmail.dat