Query on a dates?????????

[Stephen Lime]

MapServer doesn't support date types in shapefiles mainly because the underlying shapefile
library doesn't. (does ArcView?) Now, if you store your dates as another type, say int or char,
then there's hope. If using numeric types the below code should work. If using a char field then
you would need to quote the target date:

   EXPRESSION ([CPM] LT 9000 AND [GPS_DATE] EQ '19991229')

Lemme know what your particular setup is like.

Steve

>>> "Robert Day" <rday at pa.net> 07/14/00 01:22AM >>>
Dear users,

    I have included a segment of my map file that is not working. The problem is the date, but I can't find anything on date formats related to the map server's mapfile.  I know that this is very simple, but were do I look. 
Thank You,
Robert Day

LAYER
  NAME gammadata
  TYPE POINT
  STATUS ON
  MAXSCALE 5500
  DATA gammamastervp10
  SYMBOLSCALE 1200
  CLASS
    SYMBOL 4
 SIZE 1
    EXPRESSION ([CPM] LT 9000 AND [GPS_DATE] EQ 19991229)
    Name ""0 - 9000""
    COLOR 0 0 255
  END  ## CLASS
  CLASS
    SYMBOL 4
 SIZE 1
    EXPRESSION ([CPM] GT 9000 AND [CPM] LT 11000 AND [GPS_DATE] EQ 19991229)
    Name ""9000 - 11000""
    COLOR 0 255 0
  END  ## CLASS
  CLASS
    SYMBOL 4
 SIZE 1
    EXPRESSION ([CPM] GT 13000 AND [CPM] LT 13000 AND [GPS_DATE] EQ 19991229)
    Name ""11000 - 13000""
    COLOR 255 192 1
  END  ## CLASS 
  CLASS
    symbol 4
 SIZE 1
    EXPRESSION ([CPM] GT 13000 AND [GPS_DATE] EQ 19991229)
   Name ""greater than 13000""
    COLOR 255 0 0
  END  ## CLASS
 END


Robert Day 
robert.day at konsalt.com 
www.konsalt.com