[Mapserver-users] Class logical expression - date comparison

Nelson Luna Silvestre nls@myrealbox.com
Thu, 5 Dec 2002 11:11:52 -0000


Yes, if I write it like this

([DATE]>YYYYMMDD)

it works fine.
I completely missed it...

Thanks,
Nelson

-----Original Message-----
From: mapserver-users-admin@lists.gis.umn.edu
[mailto:mapserver-users-admin@lists.gis.umn.edu]On Behalf Of Paul Ramsey
Sent: quarta-feira, 4 de Dezembro de 2002 22:01
To: Daniel Morissette
Cc: Nelson Luna Silvestre; mapserver-users@lists.gis.umn.edu
Subject: Re: [Mapserver-users] Class logical expression - date
comparison


Daniel Morissette wrote:
> Nelson Luna Silvestre wrote:
> 
>>Well, I think that I'll have to add a long integer field on my shapefiles
>>and fill it with the number of days counted from 1-1-1900 to the date in
>>question - it's not a bright solution but will do.
> 
> Simply storing the date in a numeric field in the format YYYYMMDD would
> work as well (e.g. 20021204) and would allow you to use the numeric
> operators.

If you look in the DBF file, you'll see that the DBF "date" type is 
really just an eight character string in the form of YYYYMMDD. It might 
be possible to just recast your EXPRESSION to test against things of 
that form instead of the YYYY-MM-DD you are using in your example.

P.

-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey@refractions.net
      | Phone: (250) 885-0632
      \_

_______________________________________________
Mapserver-users mailing list
Mapserver-users@lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users


_______________________________________________
Mapserver-users mailing list
Mapserver-users@lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users