Hi,

I try this way but it doesn't work

SELCT * FROM TABLES WHERE ApplDt > 2007-10-01

which format I have to use.Thanks

Mark

US date format, plus with date delimiters:

SELECT * FROM TABLES WHERE ApplDt > #10/01/2007#