Database Explorer, Paradox, SQL and date fields

How to construct a correct WHERE-clause with date format fields. We have
tried:

WHERE DateField > '1997-01-01'

and several similiars, but nothings helps.

If you know anything about this, please e-mail me, m.neik...@bonsa.se.

Thanks in advance,

Mats Neikter