[mapserver-users] Comparaison date

Hi, I would like to compare current date with a field [DATE] in EXPRESSION. I try this expression but it's doesn't work : EXPRESSION (DATEDIFF('y', [DATE], GETDATE()) < 1) scott ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://l

Re: [mapserver-users] Comparaison date

Hi! Same problem here. I use this one : DATEDIFF(DD,[DAT_MEASURE],GETDATE()) < 90 In the mapfile, it works in FILTER but not in EXPRESIONN inside a CLASS... Any idea? Thx -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Comparaison-date-tp4336613p5028807.html Sent from the M

Re: [mapserver-users] Comparaison date

t: Re: [mapserver-users] Comparaison date Hi! Same problem here. I use this one : DATEDIFF(DD,[DAT_MEASURE],GETDATE()) < 90 In the mapfile, it works in FILTER but not in EXPRESIONN inside a CLASS... Any idea? Thx -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Comparai

Re: [mapserver-users] Comparaison date

Hi Steve, Thanks for your answer, these precisions are very useful. In my case (calculating a number of day),I think it will be better to create (/update) this value in the database and apply a thematic with CLASS EXPRESSIONS rather than using Mapserver to calculate on the fly in SELECT statement