<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
 /* Font Definitions */
 @font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:Consolas;
        panose-1:2 11 6 9 2 2 4 3 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif";
        color:black;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
pre
        {mso-style-priority:99;
        mso-style-link:"HTML Preformatted Char";
        margin:0in;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:"Courier New";
        color:black;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
        {mso-style-priority:34;
        margin-top:0in;
        margin-right:0in;
        margin-bottom:0in;
        margin-left:.5in;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif";
        color:black;}
span.EmailStyle18
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:windowtext;}
span.HTMLPreformattedChar
        {mso-style-name:"HTML Preformatted Char";
        mso-style-priority:99;
        mso-style-link:"HTML Preformatted";
        font-family:Consolas;
        color:black;}
span.EmailStyle21
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
        {page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext="edit">
  <o:idmap v:ext="edit" data="1" />
 </o:shapelayout></xml><![endif]-->
</head>

<body bgcolor=white lang=EN-US link=blue vlink=purple>

<div class=WordSection1>

<p class=MsoNormal><span style='color:#0F243E'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal style='text-autospace:none'><span style='color:#0F243E'>My
major question is can I do this with a String/text field?&nbsp; Its the only
way I can see keeping things in a </span><span style='font-size:9.5pt;
font-family:Consolas;color:#0F243E'>%2Y%2M%2D format&nbsp;&nbsp; ex. 092110 (Sept
21<sup>st</sup> 2010), otherwise the 0 will get removed in a numeric field<o:p></o:p></span></p>

<p class=MsoNormal style='text-autospace:none'><span style='font-size:9.5pt;
font-family:Consolas;color:#0F243E'>Can I use the format Year, Month,
Day?&nbsp; Or do I have to use Month, Day, Year?<o:p></o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'>In this example I eliminated two
expressions and focused on one Expression to see if it is working.<o:p></o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal><b><u><span style='color:#1F497D'>I kept this<o:p></o:p></span></u></b></p>

<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:blue'>&nbsp; &lt;</span><span style='font-size:8.0pt;
font-family:Consolas;color:#A31515'>map-source</span><span style='font-size:
8.0pt;font-family:Consolas;color:blue'> </span><span style='font-size:8.0pt;
font-family:Consolas;color:red'>name</span><span style='font-size:8.0pt;
font-family:Consolas;color:blue'>=</span><span style='font-size:8.0pt;
font-family:Consolas;color:windowtext'>&quot;</span><span style='font-size:
8.0pt;font-family:Consolas;color:blue'>Burglaries</span><span style='font-size:
8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>type</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>mapserver</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>&gt;</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'><o:p></o:p></span></p>

<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:blue'>&nbsp;&nbsp;&nbsp; &lt;</span><span
style='font-size:8.0pt;font-family:Consolas;color:#A31515'>file</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>&gt;</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>./maple_grove_datasets/police/Burglaries.map</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>&lt;/</span><span
style='font-size:8.0pt;font-family:Consolas;color:#A31515'>file</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>&gt;</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'><o:p></o:p></span></p>

<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:blue'>&nbsp;&nbsp;&nbsp; &lt;</span><span
style='font-size:8.0pt;font-family:Consolas;color:#A31515'>param</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>type</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>today</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>offset</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>-7</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>name</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>LASTWEEK</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>format</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>%2Y%2M%2D</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> /&gt;</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'><o:p></o:p></span></p>

<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:blue'>&nbsp;&nbsp;&nbsp; &lt;</span><span
style='font-size:8.0pt;font-family:Consolas;color:#A31515'>param</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>type</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>today</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>offset</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>-14</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>name</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>LASTTWOWEEKS</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>format</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>%2Y%2M%2D</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> /&gt;</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'><o:p></o:p></span></p>

<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:blue'>&nbsp;&nbsp;&nbsp; &lt;</span><span
style='font-size:8.0pt;font-family:Consolas;color:#A31515'>param</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>type</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>today</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>offset</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>-30</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>name</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>LASTTHIRTY</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>format</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>%2Y%2M%2D</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> /&gt;</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'><o:p></o:p></span></p>

<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:blue'>&nbsp;&nbsp;&nbsp; &lt;</span><span
style='font-size:8.0pt;font-family:Consolas;color:#A31515'>param</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>type</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>today</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>offset</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>-90</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>name</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>LASTNINTY</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>format</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>%2Y%2M%2D</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> /&gt;</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'><o:p></o:p></span></p>

<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:blue'>&nbsp;&nbsp;&nbsp; &lt;</span><span
style='font-size:8.0pt;font-family:Consolas;color:#A31515'>layer</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>name</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>Burglaries</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>&quot;</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>/&gt;</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'><o:p></o:p></span></p>

<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:blue'>&nbsp; &lt;/</span><span style='font-size:
8.0pt;font-family:Consolas;color:#A31515'>map-source</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>&gt;<o:p></o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal><b><u><span style='color:#1F497D'>In my map file I used </span></u></b><b><u><span
style='color:red'>ONLY</span></u></b><b><u><span style='color:#1F497D'> this<o:p></o:p></span></u></b></p>

<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:#632423'>CLASS<o:p></o:p></span></p>

<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:#632423'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NAME
'Last Weeks'<o:p></o:p></span></p>

<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:#632423'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EXPRESSION
('[dateValues]' &gt; '%LASTTWOWEEKS%')<o:p></o:p></span></p>

<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:#632423'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STYLE<o:p></o:p></span></p>

<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:#632423'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; COLOR
0 100 50 <o:p></o:p></span></p>

<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:#632423'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SYMBOL
&quot;bike&quot;&nbsp;&nbsp; <o:p></o:p></span></p>

<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:#632423'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SIZE
12<o:p></o:p></span></p>

<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:#632423'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END&nbsp;
<o:p></o:p></span></p>

<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:#632423'>END<o:p></o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'>Now in my data I have these
values (below), although every symbol was displayed in the map<o:p></o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'>NOTE THIS IS A TEXT FIELD<o:p></o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'>081204, 081225,090118<o:p></o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'>These values (above) for the
Year, Month, Day format specified in the map source are clearly less than the &#8220;last
two weeks&#8221;, Where as they are older than the last 14 days&#8230;.so none
of them should show up, but they do<o:p></o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'>Any thoughts<o:p></o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<div>

<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>

<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:
"Tahoma","sans-serif";color:windowtext'>
mapserver-users-bounces@lists.osgeo.org
[mailto:mapserver-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Bob
Basques<br>
<b>Sent:</b> Friday, September 17, 2010 9:25 PM<br>
<b>To:</b> mapserver-users@lists.osgeo.org<br>
<b>Subject:</b> Re: [mapserver-users] Expressions<o:p></o:p></span></p>

</div>

</div>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>A first stab at seeing more than one class, might be to try
and switch them around order wise,&nbsp; one filter may be overwriting the other
for example.<br>
<br>
bobb<br>
<br>
<br>
<br>
<br>
On 9/17/2010 8:20 AM, Jay Kapalczynski wrote: <o:p></o:p></p>

<p class=MsoNormal>I am using GeoMoose but feel this is more a question for Map
Server.<o:p></o:p></p>

<p class=MsoNormal>I am trying to sort my points by dates using the code
below&#8230;.I think that I can do this but not sure<o:p></o:p></p>

<p class=MsoNormal>Is this a viable format &#8220;2Y%2M%2D&#8221; ?&nbsp; <o:p></o:p></p>

<p class=MsoListParagraph style='text-indent:-.25in'>As for the field in the
shapefile&#8230;If I use an integer it removes the 0 from the 092110, (sept 21<sup>st</sup>
2010)<o:p></o:p></p>

<p class=MsoListParagraph style='text-indent:-.25in'>If I use a date then there
are &#8220;/&#8221;&nbsp; &#8230; 9/21/10<o:p></o:p></p>

<p class=MsoListParagraph style='text-indent:-.25in'>The only way I can see
this happening is using a text field with retains the 0 in 092110<o:p></o:p></p>

<p class=MsoNormal>&nbsp;<o:p></o:p></p>

<p class=MsoNormal>When I use the textfield &#8220;dateValues&#8221; as seen
below I can get the stars to draw but only the LASTWEEK&#8230;for some reason
the LASTTWOWEEKS does not show&nbsp; and I know that I have a few records with
dates in the last 14 days&#8230;<o:p></o:p></p>

<p class=MsoNormal>&nbsp;<o:p></o:p></p>

<p class=MsoNormal>Thoughts?<o:p></o:p></p>

<p class=MsoNormal>&nbsp;<o:p></o:p></p>

<p class=MsoNormal>THANKS&#8230;.all your help is very appreciated&#8230;.<o:p></o:p></p>

<p class=MsoNormal>&nbsp;<o:p></o:p></p>

<p class=MsoNormal>Main .xml file<o:p></o:p></p>

<p class=MsoNormal>&nbsp;<o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas;
color:blue'>&nbsp; &lt;</span><span style='font-size:9.5pt;font-family:Consolas;
color:#A31515'>map-source</span><span style='font-size:9.5pt;font-family:Consolas;
color:blue'> </span><span style='font-size:9.5pt;font-family:Consolas;
color:red'>name</span><span style='font-size:9.5pt;font-family:Consolas;
color:blue'>=</span><span style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>Burglaries</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>type</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>mapserver</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>&gt;</span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas;
color:blue'>&nbsp;&nbsp;&nbsp; &lt;</span><span style='font-size:9.5pt;
font-family:Consolas;color:#A31515'>file</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'>&gt;</span><span style='font-size:9.5pt;
font-family:Consolas'>./maple_grove_datasets/police/Burglaries.map</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>&lt;/</span><span
style='font-size:9.5pt;font-family:Consolas;color:#A31515'>file</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>&gt;</span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas;
color:blue'>&nbsp;&nbsp;&nbsp; &lt;</span><span style='font-size:9.5pt;
font-family:Consolas;color:#A31515'>param</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'> </span><span style='font-size:9.5pt;
font-family:Consolas;color:red'>type</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'>=</span><span style='font-size:9.5pt;
font-family:Consolas'>&quot;</span><span style='font-size:9.5pt;font-family:
Consolas;color:blue'>today</span><span style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>offset</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>-7</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>name</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>LASTWEEK</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>format</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>%2Y%2M%2D</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> /&gt;</span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas;
color:blue'>&nbsp;&nbsp;&nbsp; &lt;</span><span style='font-size:9.5pt;
font-family:Consolas;color:#A31515'>param</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'> </span><span style='font-size:9.5pt;
font-family:Consolas;color:red'>type</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'>=</span><span style='font-size:9.5pt;
font-family:Consolas'>&quot;</span><span style='font-size:9.5pt;font-family:
Consolas;color:blue'>today</span><span style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>offset</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>-14</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>name</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>LASTTWOWEEKS</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>format</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>%2Y%2M%2D</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> /&gt;</span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas;
color:blue'>&nbsp;&nbsp;&nbsp; &lt;</span><span style='font-size:9.5pt;
font-family:Consolas;color:#A31515'>param</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'> </span><span style='font-size:9.5pt;
font-family:Consolas;color:red'>type</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'>=</span><span style='font-size:9.5pt;
font-family:Consolas'>&quot;</span><span style='font-size:9.5pt;font-family:
Consolas;color:blue'>today</span><span style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>offset</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>-30</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>name</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>LASTTHIRTY</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>format</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>%2Y%2M%2D</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> /&gt;</span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas;
color:blue'>&nbsp;&nbsp;&nbsp; &lt;</span><span style='font-size:9.5pt;
font-family:Consolas;color:#A31515'>param</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'> </span><span style='font-size:9.5pt;
font-family:Consolas;color:red'>type</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'>=</span><span style='font-size:9.5pt;
font-family:Consolas'>&quot;</span><span style='font-size:9.5pt;font-family:
Consolas;color:blue'>today</span><span style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>offset</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>-90</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>name</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>LASTNINTY</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>format</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>%2Y%2M%2D</span><span
style='font-size:9.5pt;font-family:Consolas'>&quot;</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> /&gt;</span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas;
color:blue'>&nbsp;&nbsp;&nbsp; &lt;</span><span style='font-size:9.5pt;
font-family:Consolas;color:#A31515'>layer</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'> </span><span style='font-size:9.5pt;
font-family:Consolas;color:red'>name</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'>=</span><span style='font-size:9.5pt;
font-family:Consolas'>&quot;</span><span style='font-size:9.5pt;font-family:
Consolas;color:blue'>Burglaries</span><span style='font-size:9.5pt;font-family:
Consolas'>&quot;</span><span style='font-size:9.5pt;font-family:Consolas;
color:blue'>/&gt;</span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas;
color:blue'>&nbsp; &lt;/</span><span style='font-size:9.5pt;font-family:Consolas;
color:#A31515'>map-source</span><span style='font-size:9.5pt;font-family:Consolas;
color:blue'>&gt;</span><o:p></o:p></p>

<p class=MsoNormal>&nbsp;<o:p></o:p></p>

<p class=MsoNormal>&nbsp;<o:p></o:p></p>

<p class=MsoNormal>&nbsp;<o:p></o:p></p>

<p class=MsoNormal>.map file<o:p></o:p></p>

<p class=MsoNormal>&nbsp;<o:p></o:p></p>

<p class=MsoNormal>CL<span style='font-size:9.5pt;font-family:Consolas'>ASS</span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
NAME 'Last Weeks'</span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
EXPRESSION ('[dateValues]' &gt; '%LASTWEEK%')</span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
STYLE</span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
COLOR 0 0 0 </span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
SYMBOL &quot;star&quot;&nbsp;&nbsp; </span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
SIZE 12</span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; END&nbsp; </span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>END</span><o:p></o:p></p>

<p class=MsoNormal>CL<span style='font-size:9.5pt;font-family:Consolas'>ASS</span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
NAME 'Last Two Weeks'</span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
EXPRESSION ('[dateValues]' &gt; '%LASTTWOWEEKS%')</span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
STYLE</span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
COLOR 0 100 50 </span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
SYMBOL &quot;star&quot;&nbsp;&nbsp; </span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
SIZE 12</span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; END&nbsp; </span><o:p></o:p></p>

<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>END</span><o:p></o:p></p>

<p class=MsoNormal>&nbsp;<o:p></o:p></p>

<pre><o:p>&nbsp;</o:p></pre><pre><o:p>&nbsp;</o:p></pre><pre>_______________________________________________<o:p></o:p></pre><pre>mapserver-users mailing list<o:p></o:p></pre><pre><a
href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><o:p></o:p></pre><pre><a
href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><o:p></o:p></pre></div>

</body>

</html>