Query with dates in

[Roberto Bianconi]

Hi,

I have a shp file where data in the dbf associated are rows like this
(field names in first row):

CODE, BEGIN, END, VALUE
A1, 2002-10-03T09:30:00, 2002-10-04T09:30:00, 60.
A2, 2002-10-03T09:30:00, 2002-10-05T09:30:00, 60.

Everything works if I just retrieve CODEs with:

CLASS
          SYMBOL "cross"
          EXPRESSION ([VALUE] > 50. and [VALUE] <= 75.)
          COLOR  70 255   0
          OUTLINECOLOR 0 0 0
       END

However, if I query on dates too, then nothing is retrieved:

CLASS
          SYMBOL "cross"
          EXPRESSION ([VALUE] > 50. and [VALUE] <= 75. and [BEGIN] <
'2002-10-06T18:00:00')
          COLOR  70 255   0
          OUTLINECOLOR 0 0 0
       END

I've also tried the '2002-10-06 09:30' format, but no way...

Thanks for any comment...
Roberto