<html>
  <head>
    <style type="text/css">
      <!--
        body { margin-right: 4px; font-variant: normal; margin-left: 4px; margin-bottom: 1px; line-height: normal; margin-top: 4px }
        p { margin-bottom: 0; margin-top: 0 }
      -->
    </style>
    
  </head>
  <body>
    <p style="margin-bottom: 0; margin-top: 0">
      <font size="3" face="Comic Sans MS">Install:  </font>    </p>
    <p style="margin-bottom: 0; margin-top: 0">
      <a href="http://www.youtube.com/watch?v=r6F-D61S-h4"><u><i><font color="#0000ff" size="3" face="Comic Sans MS">http://www.youtube.com/watch?v=r6F-D61S-h4</font></i></u></a><font size="3" face="Comic Sans MS"></font>    </p>
<br>      
    <p style="margin-bottom: 0; margin-top: 0">
      <font size="3" face="Comic Sans MS">Usage examples:</font>    </p>
    <p style="margin-bottom: 0; margin-top: 0">
      <a href="http://www.youtube.com/watch?v=W4jXAaEMp2M"><u><i><font color="#0000ff" size="3" face="Comic Sans MS">http://www.youtube.com/watch?v=W4jXAaEMp2M</font></i></u></a><font size="3" face="Comic Sans MS"></font>    </p>
    <p style="margin-bottom: 0; margin-top: 0">
      <a href="http://www.youtube.com/watch?v=FsX6qwQqGgQ"><u><i><font color="#0000ff" size="3" face="Comic Sans MS">http://www.youtube.com/watch?v=FsX6qwQqGgQ</font></i></u></a><font size="3" face="Comic Sans MS"></font>    </p>
<br>      
    <p style="margin-bottom: 0; margin-top: 0">
      <font size="3" face="Comic Sans MS">There are plenty more out there via a google search . . .</font>    </p>
<br>      
    <p style="margin-bottom: 0; margin-top: 0">
      <font size="3" face="Comic Sans MS">bobb</font>    </p>
<br>      <br><br>
    <p style="margin-bottom: 0; margin-top: 0">
      <br>
      <br>
      >>> David William Bitner <bitner@gyttja.org> wrote:<br>    </p>
    <div style="margin-right: 0; border-left: solid 1px #050505; background-color: #f3f3f3; margin-left: 15px; margin-bottom: 0; padding-left: 7px; margin-top: 0">
      <p style="margin-bottom: 0; margin-top: 0">
        Jay,      </p>
      <div content="text/html; charset=WINDOWS-1252" http-equiv="Content-Type">
        <p style="margin-bottom: 0; margin-top: 0">
          <br>
                  </p>
      </div>
      <div>
        <p style="margin-bottom: 0; margin-top: 0">
          I am not exactly sure how the params work in GeoMoose. One tip in general to be able to isolate the problem to either GeoMoose or MapServer is to look at the actual requests that are being made to MapServer. One of the easiest ways to do this is to either use the FireBug extension in FireFox or the Javascript Console in Chrome. With this take a look at the URL that is being sent to MapServer and see what is in the parameter &LASTWEEK=.        </p>
      </div>
      <div>
        <p style="margin-bottom: 0; margin-top: 0">
          <br>
                  </p>
      </div>
      <div>
        <p style="margin-bottom: 0; margin-top: 0">
          <br>
                  </p>
      </div>
      <div>
        <p style="margin-bottom: 0; margin-top: 0">
          David<br><br>        </p>
        <div class="gmail_quote">
          <p style="margin-bottom: 0; margin-top: 0">
            On Wed, Sep 29, 2010 at 10:49 AM, Jay Kapalczynski          </p>
          <div dir="ltr">
            <p style="margin-bottom: 0; margin-top: 0">
              <<a href="mailto:jkapalczynski@ci.maple-grove.mn.us">jkapalczynski@ci.maple-grove.mn.us</a>>            </p>
          </div>
          <p style="margin-bottom: 0; margin-top: 0">
            wrote:<br>          </p>
          <blockquote style="margin-right: 0; border-left: 1px #ccc solid; margin-left: 0; margin-bottom: 0; padding-left: 0; margin-top: 0" class="gmail_quote">
            <div link="blue" lang="EN-US" vlink="purple">
              <div>
                <p style="margin-bottom: 0; margin-top: 0">
                  I thank you for your response....greatly appreciated as I cannot figure this out....                </p>
                <p style="margin-bottom: 0; margin-top: 0">
                  I know that I have 4 features in the dataset that have a value of 20100916 that’s 13 days ago....so with the expression below those 4 or 5 features should show up....but nothing shows up                </p>
<br>                  
                <p style="margin-bottom: 0; margin-top: 0">
                  IncidentDa is the field (long integer)                </p>
                <p style="margin-bottom: 0; margin-top: 0">
                  Param type is specifying YYYYMMDD my data has values of 20100916 (13 days)                </p>
<br>                  
                <p style="margin-bottom: 0; margin-top: 0">
                  I have no idea what could be wrong…Thank you all for your help….                </p>
<br>                  <br>
                <div style="color: black; font-size: 9.0pt">
                  <p style="margin-bottom: 0; margin-top: 0">
                    .XML file                  </p>
                </div>
                <div class="im">
<br>                    
                  <div style="color: #632423; font-size: 9.0pt">
                    <p style="margin-bottom: 0; margin-top: 0">
                      <map-source name="Burglaries" type="mapserver">                    </p>
                  </div>
<br>                    
                  <div style="color: #632423; font-size: 9.0pt">
                    <p style="margin-bottom: 0; margin-top: 0">
                      <file>./maple_grove_datasets/police/Burglaries.map</file>                    </p>
                  </div>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt">
                  <p style="margin-bottom: 0; margin-top: 0">
                    <param type="today" offset="-90" name="LASTNINTY" format="%4Y%2M%2D" />                  </p>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt">
                  <p style="margin-bottom: 0; margin-top: 0">
                    <param type="today" offset="-30" name="LASTTHIRTY" format="%4Y%2M%2D" />                  </p>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt">
                  <p style="margin-bottom: 0; margin-top: 0">
                    <param type="today" offset="-14" name="LASTTWOWEEKS" format="%4Y%2M%2D" />                  </p>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt">
                  <p style="margin-bottom: 0; margin-top: 0">
                    <param type="today" offset="-7" name="LASTWEEK" format="%4Y%2M%2D" />                  </p>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt">
                  <p style="margin-bottom: 0; margin-top: 0">
                    <param type="today" offset="0" name="TODAY" format="%4Y%2M%2D" />                  </p>
                </div>
                <div class="im">
<br>                    
                  <div style="color: #632423; font-size: 9.0pt">
                    <p style="margin-bottom: 0; margin-top: 0">
                      <layer name="Burglaries"/>                    </p>
                  </div>
<br>                    
                  <div style="color: #632423; font-size: 9.0pt">
                    <p style="margin-bottom: 0; margin-top: 0">
                      </map-source>                    </p>
                  </div>
<br>                    
                  <div style="color: #632423; font-size: 9.0pt">
<br>                      
                  </div>
                </div>
<br>                  
                <div style="color: black; font-size: 9.0pt">
                  <p style="margin-bottom: 0; margin-top: 0">
                    .MAP file                  </p>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt">
                  <p style="margin-bottom: 0; margin-top: 0">
                    CLASS                  </p>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt">
                  <p style="margin-bottom: 0; margin-top: 0">
                    NAME 'Last Weeks'                  </p>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt">
                  <p style="margin-bottom: 0; margin-top: 0">
                    EXPRESSION ('[IncidentDa]' > '%LASTTWOWEEKS%' && '[IncidentDa]' < '%LASTWEEK%')                  </p>
                </div>
                <div class="im">
<br>                    
                  <div style="color: #632423; font-size: 9.0pt">
                    <p style="margin-bottom: 0; margin-top: 0">
                      STYLE                    </p>
                  </div>
<br>                    
                  <div style="color: #632423; font-size: 9.0pt">
                    <p style="margin-bottom: 0; margin-top: 0">
                      COLOR 0 100 50                    </p>
                  </div>
<br>                    
                  <div style="color: #632423; font-size: 9.0pt">
                    <p style="margin-bottom: 0; margin-top: 0">
                      SYMBOL "bike"                    </p>
                  </div>
<br>                    
                  <div style="color: #632423; font-size: 9.0pt">
                    <p style="margin-bottom: 0; margin-top: 0">
                      SIZE 12                    </p>
                  </div>
<br>                    
                  <div style="color: #632423; font-size: 9.0pt">
                    <p style="margin-bottom: 0; margin-top: 0">
                      END                    </p>
                  </div>
<br>                    
                  <div style="color: #632423; font-size: 9.0pt">
                    <p style="margin-bottom: 0; margin-top: 0">
                      END                    </p>
                  </div>
<br>                    
                </div>
                <p style="margin-bottom: 0; margin-top: 0">
                  =======================================                </p>
<br>                  
                <p style="margin-bottom: 0; margin-top: 0">
                  BUT if I simply place this in there I get all the points…so something is weird here because most of the dates are older than 7 days.                </p>
<br>                  
                <div style="color: #632423; font-size: 9.0pt; font-family: Consolas">
                  <p style="margin-bottom: 0; margin-top: 0">
                    CLASS                  </p>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt; font-family: Consolas">
                  <p style="margin-bottom: 0; margin-top: 0">
                    NAME 'Last Weeks'                  </p>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt; font-family: Consolas">
                  <p style="margin-bottom: 0; margin-top: 0">
                    EXPRESSION ('[IncidentDa]' > '%LASTWEEK%’)                  </p>
                </div>
                <div class="im">
<br>                    
                  <div style="color: #632423; font-size: 9.0pt; font-family: Consolas">
                    <p style="margin-bottom: 0; margin-top: 0">
                      STYLE                    </p>
                  </div>
<br>                    
                  <div style="color: #632423; font-size: 9.0pt; font-family: Consolas">
                    <p style="margin-bottom: 0; margin-top: 0">
                      COLOR 0 0 0                    </p>
                  </div>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt; font-family: Consolas">
                  <p style="margin-bottom: 0; margin-top: 0">
                    SYMBOL "tent"                  </p>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt; font-family: Consolas">
                  <p style="margin-bottom: 0; margin-top: 0">
                    SIZE 12                  </p>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt; font-family: Consolas">
                  <p style="margin-bottom: 0; margin-top: 0">
                    END                  </p>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt; font-family: Consolas">
                  <p style="margin-bottom: 0; margin-top: 0">
                    #END                  </p>
                </div>
                <div>
                  <div>
<br>                      
                  </div>
                  <div class="h5">
<br>                      <br>
                    <p style="margin-bottom: 0; margin-top: 0">
                      -----Original Message-----<br>From: <a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>] On Behalf Of Stephen Woodbridge<br>Sent: Wednesday, September 29, 2010 8:19 AM<br>To: <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>Subject: Re: [mapserver-users] Expressions                    </p>
<br>                      
                    <p style="margin-bottom: 0; margin-top: 0">
                      In EXPRESSIONS you can evaluate any of the following:                    </p>
<br>                      
                    <p style="margin-bottom: 0; margin-top: 0">
                      1. Regular expressions treating the value as a string                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      2. numeric expressions using booleans like ==,<,>,<=,>=                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      3. string expressions like ==, !=, and I think strlen()                    </p>
<br>                      
                    <p style="margin-bottom: 0; margin-top: 0">
                      So if you converted you dates into a format like YYYYMMDD then it would                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      be easy to use a numeric expression like:                    </p>
<br>                      
                    <p style="margin-bottom: 0; margin-top: 0">
                      EXPRESSION ('[dateValues]' > '%STARTDATE%' && '[dateValues]' < '%ENDDATE%')                    </p>
<br>                      
                    <p style="margin-bottom: 0; margin-top: 0">
                      or                    </p>
<br>                      
                    <p style="margin-bottom: 0; margin-top: 0">
                      EXPRESSION ('[dateValues]' > '%STARTDATE%')                    </p>
<br>                      
                    <p style="margin-bottom: 0; margin-top: 0">
                      where STARTDATE is the YYYYMMDD value of two weeks ago and ENDDATE would                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      be in the same format and allow you to extract record betwee any two                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      start and end dates.                    </p>
<br>                      
                    <p style="margin-bottom: 0; margin-top: 0">
                      Or you might be able to figure out a complex regular expression the                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      represents the last two weeks like:                    </p>
<br>                      
                    <p style="margin-bottom: 0; margin-top: 0">
                      EXPRESSION ('[dateValues]' =~ '/%LASTTWOWEEKS%/')                    </p>
<br>                      
                    <p style="margin-bottom: 0; margin-top: 0">
                      I'm not sure what you would need for the regular expression.                    </p>
<br>                      
                    <p style="margin-bottom: 0; margin-top: 0">
                      -Steve W                    </p>
<br>                      
                    <p style="margin-bottom: 0; margin-top: 0">
                      On 9/28/2010 4:23 PM, Jay Kapalczynski wrote:                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > Anyone have anymore ideas about this….                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > I have a string field with values                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > And the code below. The expression does not seem to be running…if I only                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > use LASTTWOWEEKS it still draws all the points….and I know there are                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > values in there from 2008                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > Thanks                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > *From:* <a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > [mailto:<a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>] *On Behalf Of *Jay                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > Kapalczynski                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > *Sent:* Tuesday, September 21, 2010 9:51 AM                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > *To:* 'Bob Basques'; <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > *Subject:* RE: [mapserver-users] Expressions                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > My major question is can I do this with a String/text field? Its the                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > only way I can see keeping things in a %2Y%2M%2D format ex. 092110 (Sept                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > 21^st 2010), otherwise the 0 will get removed in a numeric field                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > Can I use the format Year, Month, Day? Or do I have to use Month, Day, Year?                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > In this example I eliminated two expressions and focused on one                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > Expression to see if it is working.                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > *_I kept this_*                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > <map-source name="Burglaries" type="mapserver">                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > <file>./maple_grove_datasets/police/Burglaries.map</file>                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > <param type="today" offset="-7" name="LASTWEEK" format="%2Y%2M%2D" />                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > <param type="today" offset="-14" name="LASTTWOWEEKS" format="%2Y%2M%2D" />                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > <param type="today" offset="-30" name="LASTTHIRTY" format="%2Y%2M%2D" />                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > <param type="today" offset="-90" name="LASTNINTY" format="%2Y%2M%2D" />                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > <layer name="Burglaries"/>                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > </map-source>                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > *_In my map file I used _**_ONLY_**_ this_*                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > CLASS                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > NAME 'Last Weeks'                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > EXPRESSION ('[dateValues]' > '%LASTTWOWEEKS%')                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > STYLE                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > COLOR 0 100 50                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > SYMBOL "bike"                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > SIZE 12                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > END                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > END                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > Now in my data I have these values (below), although every symbol was                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > displayed in the map                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > NOTE THIS IS A TEXT FIELD                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > 081204, 081225,090118                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > These values (above) for the Year, Month, Day format specified in the                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > map source are clearly less than the “last two weeks”, Where as they are                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > older than the last 14 days….so none of them should show up, but they do                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > Any thoughts                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > *From:* <a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > [mailto:<a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>] *On Behalf Of *Bob Basques                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > *Sent:* Friday, September 17, 2010 9:25 PM                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > *To:* <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > *Subject:* Re: [mapserver-users] Expressions                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > A first stab at seeing more than one class, might be to try and switch                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > them around order wise, one filter may be overwriting the other for example.                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > bobb                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > On 9/17/2010 8:20 AM, Jay Kapalczynski wrote:                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > I am using GeoMoose but feel this is more a question for Map Server.                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > I am trying to sort my points by dates using the code below….I think                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > that I can do this but not sure                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > Is this a viable format “2Y%2M%2D” ?                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > As for the field in the shapefile…If I use an integer it removes the 0                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > from the 092110, (sept 21^st 2010)                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > If I use a date then there are “/” … 9/21/10                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > The only way I can see this happening is using a text field with retains                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > the 0 in 092110                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > When I use the textfield “dateValues” as seen below I can get the stars                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > to draw but only the LASTWEEK…for some reason the LASTTWOWEEKS does not                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > show and I know that I have a few records with dates in the last 14 days…                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > Thoughts?                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > THANKS….all your help is very appreciated….                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > Main .xml file                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > <map-source name="Burglaries" type="mapserver">                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > <file>./maple_grove_datasets/police/Burglaries.map</file>                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > <param type="today" offset="-7" name="LASTWEEK" format="%2Y%2M%2D" />                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > <param type="today" offset="-14" name="LASTTWOWEEKS" format="%2Y%2M%2D" />                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > <param type="today" offset="-30" name="LASTTHIRTY" format="%2Y%2M%2D" />                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > <param type="today" offset="-90" name="LASTNINTY" format="%2Y%2M%2D" />                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > <layer name="Burglaries"/>                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > </map-source>                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > .map file                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > CLASS                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > NAME 'Last Weeks'                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > EXPRESSION ('[dateValues]' > '%LASTWEEK%')                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > STYLE                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > COLOR 0 0 0                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > SYMBOL "star"                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > SIZE 12                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > END                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > END                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > CLASS                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > NAME 'Last Two Weeks'                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > EXPRESSION ('[dateValues]' > '%LASTTWOWEEKS%')                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > STYLE                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > COLOR 0 100 50                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > SYMBOL "star"                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > SIZE 12                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > END                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > END                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > _______________________________________________                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > mapserver-users mailing list                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a> <mailto:<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>>                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a>                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      >                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > _______________________________________________                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > mapserver-users mailing list                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      > <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a>                    </p>
<br>                      
                    <p style="margin-bottom: 0; margin-top: 0">
                      _______________________________________________                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      mapserver-users mailing list                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a>                    </p>
                  </div>
                </div>
              </div>
            </div>
            <p style="margin-bottom: 0; margin-top: 0">
              <br>
              _______________________________________________<br>mapserver-users mailing list<br><a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br><br>            </p>
          </blockquote>
        </div>
        <p style="margin-bottom: 0; margin-top: 0">
          <br>
          <br clear="all">
          <br>
          --<br>************************************<br>David William Bitner<br>
        </p>
      </div>
    </div>
  </body>
</html>