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:[EMAIL PROTECTED] Eijnden, B. van den (Bart) Verzonden: donderdag 6 april 2006 14:35 Aan: [email protected] 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. ************************************************************************
