date filters

[Eijnden, B. van den (Bart)]

Fixed, apparently I had to use the date in a similar way as Mapserver
displays them itself, so this worked:

FILTER ( '[EINDDATUM]' ge '200507' )

If I use OGR as connection type I needed to use 2005/07 for the expression
.....

But according to the documentation Mapserver should also accept 2005-07 or
not?

http://mapserver.gis.umn.edu/docs/howto/msexpressions

Section: temporal expressions

Best regards,
Bart

-----Oorspronkelijk bericht-----
Van: UMN MapServer Users List
[mailto:MAPSERVER-USERS at LISTS.UMN.EDU]Namens Eijnden, B. van den (Bart)
Verzonden: donderdag 6 april 2006 14:35
Aan: MAPSERVER-USERS at LISTS.UMN.EDU
Onderwerp: [UMN_MAPSERVER-USERS] date filters


Hi list,

I am having no luck with trying to apply a date filter to a LAYER, normal
string filters work fine. It's a shapefile which has a dbf with a column of
type date. Values in there are e.g. (12 april 2005):

12-4-2005

The filter I am currently trying is:

FILTER ( '[EINDDATUM]' ge '2005-07' )

But this also select things like in april 2005.

What am I doing wrong? Thanks in advance. I am using 4.8.1 PHP/Mapscript on
RHE Linux.

Best regards,
Bart


Disclaimer
************************************************************************
Aan dit bericht kunnen geen rechten worden ontleend. Dit bericht is
uitsluitend bestemd voor de geadresseerde. Als u dit bericht per abuis
hebt ontvangen, wordt u verzocht het te vernietigen en de afzender te 
informeren. Wij adviseren u om bij twijfel over de juistheid of de 
volledigheid van de mail contact met afzender op te nemen.

This message shall not constitute any rights or obligations.
This message is intended solely for the addressee.
If you have received this message in error, please delete it and
notify the sender immediately. When in doubt whether this message
is correct or complete, please contact the sender.
************************************************************************


Disclaimer
************************************************************************
Aan dit bericht kunnen geen rechten worden ontleend. Dit bericht is
uitsluitend bestemd voor de geadresseerde. Als u dit bericht per abuis
hebt ontvangen, wordt u verzocht het te vernietigen en de afzender te 
informeren. Wij adviseren u om bij twijfel over de juistheid of de 
volledigheid van de mail contact met afzender op te nemen.

This message shall not constitute any rights or obligations.
This message is intended solely for the addressee.
If you have received this message in error, please delete it and
notify the sender immediately. When in doubt whether this message
is correct or complete, please contact the sender.
************************************************************************