<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: &nbsp;</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&#63;v&#61;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&#63;v&#61;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&#63;v&#61;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>
      &gt;&gt;&gt; David William Bitner &lt;bitner@gyttja.org&gt; 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&#44;      </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 &amp;LASTWEEK&#61;.        </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&#44; Sep 29&#44; 2010 at 10:49 AM&#44; Jay Kapalczynski          </p>
          <div dir="ltr">
            <p style="margin-bottom: 0; margin-top: 0">
              &lt;<a href="mailto:jkapalczynski@ci.maple-grove.mn.us">jkapalczynski@ci.maple-grove.mn.us</a>&gt;            </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&#8217;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 &#40;long integer&#41;                </p>
                <p style="margin-bottom: 0; margin-top: 0">
                  Param type is specifying YYYYMMDD my data has values of 20100916 &#40;13 days&#41;                </p>
<br>                  
                <p style="margin-bottom: 0; margin-top: 0">
                  I have no idea what could be wrong&#8230;Thank you all for your help&#8230;.                </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">
                      &lt;map-source name&#61;&quot;Burglaries&quot; type&#61;&quot;mapserver&quot;&gt;                    </p>
                  </div>
<br>                    
                  <div style="color: #632423; font-size: 9.0pt">
                    <p style="margin-bottom: 0; margin-top: 0">
                      &lt;file&gt;./maple_grove_datasets/police/Burglaries.map&lt;/file&gt;                    </p>
                  </div>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt">
                  <p style="margin-bottom: 0; margin-top: 0">
                    &lt;param type&#61;&quot;today&quot; offset&#61;&quot;-90&quot; name&#61;&quot;LASTNINTY&quot; format&#61;&quot;&#37;4Y&#37;2M&#37;2D&quot; /&gt;                  </p>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt">
                  <p style="margin-bottom: 0; margin-top: 0">
                    &lt;param type&#61;&quot;today&quot; offset&#61;&quot;-30&quot; name&#61;&quot;LASTTHIRTY&quot; format&#61;&quot;&#37;4Y&#37;2M&#37;2D&quot; /&gt;                  </p>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt">
                  <p style="margin-bottom: 0; margin-top: 0">
                    &lt;param type&#61;&quot;today&quot; offset&#61;&quot;-14&quot; name&#61;&quot;LASTTWOWEEKS&quot; format&#61;&quot;&#37;4Y&#37;2M&#37;2D&quot; /&gt;                  </p>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt">
                  <p style="margin-bottom: 0; margin-top: 0">
                    &lt;param type&#61;&quot;today&quot; offset&#61;&quot;-7&quot; name&#61;&quot;LASTWEEK&quot; format&#61;&quot;&#37;4Y&#37;2M&#37;2D&quot; /&gt;                  </p>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt">
                  <p style="margin-bottom: 0; margin-top: 0">
                    &lt;param type&#61;&quot;today&quot; offset&#61;&quot;0&quot; name&#61;&quot;TODAY&quot; format&#61;&quot;&#37;4Y&#37;2M&#37;2D&quot; /&gt;                  </p>
                </div>
                <div class="im">
<br>                    
                  <div style="color: #632423; font-size: 9.0pt">
                    <p style="margin-bottom: 0; margin-top: 0">
                      &lt;layer name&#61;&quot;Burglaries&quot;/&gt;                    </p>
                  </div>
<br>                    
                  <div style="color: #632423; font-size: 9.0pt">
                    <p style="margin-bottom: 0; margin-top: 0">
                      &lt;/map-source&gt;                    </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 &#39;Last Weeks&#39;                  </p>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt">
                  <p style="margin-bottom: 0; margin-top: 0">
                    EXPRESSION &#40;&#39;&#91;IncidentDa&#93;&#39; &gt; &#39;&#37;LASTTWOWEEKS&#37;&#39; &amp;&amp; &#39;&#91;IncidentDa&#93;&#39; &lt; &#39;&#37;LASTWEEK&#37;&#39;&#41;                  </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 &quot;bike&quot;                    </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">
                  &#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;                </p>
<br>                  
                <p style="margin-bottom: 0; margin-top: 0">
                  BUT if I simply place this in there I get all the points&#8230;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 &#39;Last Weeks&#39;                  </p>
                </div>
<br>                  
                <div style="color: #632423; font-size: 9.0pt; font-family: Consolas">
                  <p style="margin-bottom: 0; margin-top: 0">
                    EXPRESSION &#40;&#39;&#91;IncidentDa&#93;&#39; &gt; &#39;&#37;LASTWEEK&#37;&#8217;&#41;                  </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 &quot;tent&quot;                  </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">
                    &#35;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>&nbsp;&#91;mailto:<a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>&#93; On Behalf Of Stephen Woodbridge<br>Sent: Wednesday&#44; September 29&#44; 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: &#91;mapserver-users&#93; 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 &#61;&#61;&#44;&lt;&#44;&gt;&#44;&lt;&#61;&#44;&gt;&#61;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      3. string expressions like &#61;&#61;&#44; &#33;&#61;&#44; and I think strlen&#40;&#41;                    </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 &#40;&#39;&#91;dateValues&#93;&#39; &gt; &#39;&#37;STARTDATE&#37;&#39; &amp;&amp; &#39;&#91;dateValues&#93;&#39; &lt; &#39;&#37;ENDDATE&#37;&#39;&#41;                    </p>
<br>                      
                    <p style="margin-bottom: 0; margin-top: 0">
                      or                    </p>
<br>                      
                    <p style="margin-bottom: 0; margin-top: 0">
                      EXPRESSION &#40;&#39;&#91;dateValues&#93;&#39; &gt; &#39;&#37;STARTDATE&#37;&#39;&#41;                    </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 &#40;&#39;&#91;dateValues&#93;&#39; &#61;&#126;&nbsp;&#39;/&#37;LASTTWOWEEKS&#37;/&#39;&#41;                    </p>
<br>                      
                    <p style="margin-bottom: 0; margin-top: 0">
                      I&#39;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&#44; Jay Kapalczynski wrote:                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; Anyone have anymore ideas about this&#8230;.                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; I have a string field with values                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; And the code below. The expression does not seem to be running&#8230;if I only                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; use LASTTWOWEEKS it still draws all the points&#8230;.and I know there are                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; values in there from 2008                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; Thanks                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &#42;From:&#42; <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">
                      &gt; &#91;mailto:<a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>&#93; &#42;On Behalf Of &#42;Jay                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; Kapalczynski                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &#42;Sent:&#42; Tuesday&#44; September 21&#44; 2010 9:51 AM                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &#42;To:&#42; &#39;Bob Basques&#39;&#59; <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">
                      &gt; &#42;Subject:&#42; RE: &#91;mapserver-users&#93; Expressions                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; My major question is can I do this with a String/text field&#63; Its the                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; only way I can see keeping things in a &#37;2Y&#37;2M&#37;2D format ex. 092110 &#40;Sept                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; 21&#94;st 2010&#41;&#44; otherwise the 0 will get removed in a numeric field                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; Can I use the format Year&#44; Month&#44; Day&#63; Or do I have to use Month&#44; Day&#44; Year&#63;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; In this example I eliminated two expressions and focused on one                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; Expression to see if it is working.                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &#42;_I kept this_&#42;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &lt;map-source name&#61;&quot;Burglaries&quot; type&#61;&quot;mapserver&quot;&gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &lt;file&gt;./maple_grove_datasets/police/Burglaries.map&lt;/file&gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &lt;param type&#61;&quot;today&quot; offset&#61;&quot;-7&quot; name&#61;&quot;LASTWEEK&quot; format&#61;&quot;&#37;2Y&#37;2M&#37;2D&quot; /&gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &lt;param type&#61;&quot;today&quot; offset&#61;&quot;-14&quot; name&#61;&quot;LASTTWOWEEKS&quot; format&#61;&quot;&#37;2Y&#37;2M&#37;2D&quot; /&gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &lt;param type&#61;&quot;today&quot; offset&#61;&quot;-30&quot; name&#61;&quot;LASTTHIRTY&quot; format&#61;&quot;&#37;2Y&#37;2M&#37;2D&quot; /&gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &lt;param type&#61;&quot;today&quot; offset&#61;&quot;-90&quot; name&#61;&quot;LASTNINTY&quot; format&#61;&quot;&#37;2Y&#37;2M&#37;2D&quot; /&gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &lt;layer name&#61;&quot;Burglaries&quot;/&gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &lt;/map-source&gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &#42;_In my map file I used _&#42;&#42;_ONLY_&#42;&#42;_ this_&#42;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; CLASS                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; NAME &#39;Last Weeks&#39;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; EXPRESSION &#40;&#39;&#91;dateValues&#93;&#39; &gt; &#39;&#37;LASTTWOWEEKS&#37;&#39;&#41;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; STYLE                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; COLOR 0 100 50                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; SYMBOL &quot;bike&quot;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; SIZE 12                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; END                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; END                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; Now in my data I have these values &#40;below&#41;&#44; although every symbol was                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; displayed in the map                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; NOTE THIS IS A TEXT FIELD                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; 081204&#44; 081225&#44;090118                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; These values &#40;above&#41; for the Year&#44; Month&#44; Day format specified in the                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; map source are clearly less than the&nbsp;&#8220;last two weeks&#8221;&#44; Where as they are                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; older than the last 14 days&#8230;.so none of them should show up&#44; but they do                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; Any thoughts                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &#42;From:&#42; <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">
                      &gt; &#91;mailto:<a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>&#93; &#42;On Behalf Of &#42;Bob Basques                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &#42;Sent:&#42; Friday&#44; September 17&#44; 2010 9:25 PM                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &#42;To:&#42; <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">
                      &gt; &#42;Subject:&#42; Re: &#91;mapserver-users&#93; Expressions                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; A first stab at seeing more than one class&#44; might be to try and switch                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; them around order wise&#44; one filter may be overwriting the other for example.                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; bobb                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; On 9/17/2010 8:20 AM&#44; Jay Kapalczynski wrote:                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; I am using GeoMoose but feel this is more a question for Map Server.                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; I am trying to sort my points by dates using the code below&#8230;.I think                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; that I can do this but not sure                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; Is this a viable format&nbsp;&#8220;2Y&#37;2M&#37;2D&#8221;&nbsp;&#63;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; As for the field in the shapefile&#8230;If I use an integer it removes the 0                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; from the 092110&#44; &#40;sept 21&#94;st 2010&#41;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; If I use a date then there are&nbsp;&#8220;/&#8221;&nbsp;&#8230;&nbsp;9/21/10                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; The only way I can see this happening is using a text field with retains                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; the 0 in 092110                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; When I use the textfield&nbsp;&#8220;dateValues&#8221;&nbsp;as seen below I can get the stars                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; to draw but only the LASTWEEK&#8230;for some reason the LASTTWOWEEKS does not                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; show and I know that I have a few records with dates in the last 14 days&#8230;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; Thoughts&#63;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; THANKS&#8230;.all your help is very appreciated&#8230;.                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; Main .xml file                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &lt;map-source name&#61;&quot;Burglaries&quot; type&#61;&quot;mapserver&quot;&gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &lt;file&gt;./maple_grove_datasets/police/Burglaries.map&lt;/file&gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &lt;param type&#61;&quot;today&quot; offset&#61;&quot;-7&quot; name&#61;&quot;LASTWEEK&quot; format&#61;&quot;&#37;2Y&#37;2M&#37;2D&quot; /&gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &lt;param type&#61;&quot;today&quot; offset&#61;&quot;-14&quot; name&#61;&quot;LASTTWOWEEKS&quot; format&#61;&quot;&#37;2Y&#37;2M&#37;2D&quot; /&gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &lt;param type&#61;&quot;today&quot; offset&#61;&quot;-30&quot; name&#61;&quot;LASTTHIRTY&quot; format&#61;&quot;&#37;2Y&#37;2M&#37;2D&quot; /&gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &lt;param type&#61;&quot;today&quot; offset&#61;&quot;-90&quot; name&#61;&quot;LASTNINTY&quot; format&#61;&quot;&#37;2Y&#37;2M&#37;2D&quot; /&gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &lt;layer name&#61;&quot;Burglaries&quot;/&gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; &lt;/map-source&gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; .map file                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; CLASS                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; NAME &#39;Last Weeks&#39;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; EXPRESSION &#40;&#39;&#91;dateValues&#93;&#39; &gt; &#39;&#37;LASTWEEK&#37;&#39;&#41;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; STYLE                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; COLOR 0 0 0                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; SYMBOL &quot;star&quot;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; SIZE 12                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; END                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; END                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; CLASS                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; NAME &#39;Last Two Weeks&#39;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; EXPRESSION &#40;&#39;&#91;dateValues&#93;&#39; &gt; &#39;&#37;LASTTWOWEEKS&#37;&#39;&#41;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; STYLE                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; COLOR 0 100 50                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; SYMBOL &quot;star&quot;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; SIZE 12                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; END                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; END                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; _______________________________________________                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; mapserver-users mailing list                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>&nbsp;&lt;mailto:<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>&gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; <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">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt;                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; _______________________________________________                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; mapserver-users mailing list                    </p>
                    <p style="margin-bottom: 0; margin-top: 0">
                      &gt; <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">
                      &gt; <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>&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;<br>David William Bitner<br>
        </p>
      </div>
    </div>
  </body>
</html>