Class or filter expression on date field in shapefile

[Andreas Albarello]

Ei Fujioka wrote:
> What is the date format for class/filter expression?
> I use Mapserver 4.2.

> I tried the following expression but failed.
> EXPRESSION ([DATE_S] > '2003-01-01')

Ei,

I happened to stumble upon some MapServer 4.2 code today and a quick 
look at the lexer and parser made me think that the following expression 
might even work:

EXPRESSION ('[DATE_S]' > '2003-01-01')

Note that it was single quotes back then, not backticks, and the field 
needs to be quoted too. Besides, YYYY-MM-DD seems to be the only 
recognized format, any other character combination is treated as a 
string. I wasn't able to actually test this, though, so take it FWIW.

Best regards,

-- 
--------------------------------------------------------------------
Andreas Albarello
Analysis & SW Development

Territorium Online srl/GmbH
Via Buozzi/Buozzistraße 12 - I 39100 Bolzano/Bozen
email: andreas.albarello at territoriumonline.com
web:   www.territoriumonline.com
--------------------------------------------------------------------