[mapserver-users] Mapserver filter/expression by DATE

[Daniël Robins]

Hi Jeff,

after experimenting a bit with the queries I ended up using the EXTRACT 
function and make a filter based on that.
Giving it some second thought, made me realize this is actually much easier:
FILTER ("startdate" <= '2016-01-01' AND "enddate" >= '2016-12-31')

For the time being I think this will work fine until we've added code 
for the scrolling feature similar to topotijdreis.nl

Met vriendelijke groet,

Daniël Robins
GISArts
www.gisarts.nl
06 13526214

Op 9-8-2016 15:00, Jeff McKenna schreef:
> Hi Daniel,
>
> I think for the thousands of readers on this mailing list, you really 
> need to give examples of your psql queries that you are trying (people 
> in these open communities find editing your mistakes much easier than 
> suggesting new solutions).  So, dive into the commandline :)  Do some 
> tests with the tools I mentioned, then come back here and paste in 
> your query syntax for the mailing list readers, I bet someone will be 
> able to help you then.
>
> -jeff
>
>