<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt"><div><span>Dates aren't handled well by MapServer. Nor shapefiles. You'll need to make sure there is a text field in your shapefile or database that formats the date as you'd like.<br></span></div><div><br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <div style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Ed Boesenberg <boesiii@yahoo.com><br> <b><span style="font-weight: bold;">To:</span></b> "'Bistrais, Bob'" <Bob.Bistrais@maine.gov>; geomoose-users@lists.osgeo.org <br> <b><span style="font-weight: bold;">Sent:</span></b> Wednesday,
May 30, 2012 7:11 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [Geomoose-users] Format numeric query result<br> </font> </div> <br>
<div id="yiv506451733"><style><!--
#yiv506451733
_filtered #yiv506451733 {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;}
_filtered #yiv506451733 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
_filtered #yiv506451733 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
#yiv506451733
#yiv506451733 p.yiv506451733MsoNormal, #yiv506451733 li.yiv506451733MsoNormal, #yiv506451733 div.yiv506451733MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"sans-serif";}
#yiv506451733 a:link, #yiv506451733 span.yiv506451733MsoHyperlink
{color:blue;text-decoration:underline;}
#yiv506451733 a:visited, #yiv506451733 span.yiv506451733MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
#yiv506451733 span.yiv506451733EmailStyle17
{font-family:"sans-serif";color:windowtext;}
#yiv506451733 span.yiv506451733EmailStyle18
{font-family:"sans-serif";color:#1F497D;}
#yiv506451733 .yiv506451733MsoChpDefault
{font-size:10.0pt;}
_filtered #yiv506451733 {margin:1.0in 1.0in 1.0in 1.0in;}
#yiv506451733 div.yiv506451733WordSection1
{}
--></style><div><div class="yiv506451733WordSection1"><div class="yiv506451733MsoNormal"><span style="color:#1F497D;">Bob,</span></div><div class="yiv506451733MsoNormal"><span style="color:#1F497D;"> </span></div><div class="yiv506451733MsoNormal"><span style="color:#1F497D;">To format the double use: [item name=FIELD precision=0]</span></div><div class="yiv506451733MsoNormal"><span style="color:#1F497D;"> </span></div><div class="yiv506451733MsoNormal"><span style="color:#1F497D;">I am not sure about the date.</span></div><div class="yiv506451733MsoNormal"><span style="color:#1F497D;"> </span></div><div class="yiv506451733MsoNormal"><span style="color:#1F497D;">Ed</span></div><div class="yiv506451733MsoNormal"><span style="color:#1F497D;"> </span></div><div><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in;"><div class="yiv506451733MsoNormal"><b><span
style="font-size:10.0pt;font-family:"sans-serif";">From:</span></b><span style="font-size:10.0pt;font-family:"sans-serif";"> geomoose-users-bounces@lists.osgeo.org [mailto:geomoose-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Bistrais, Bob<br><b>Sent:</b> Tuesday, May 29, 2012 4:34 PM<br><b>To:</b> geomoose-users@lists.osgeo.org<br><b>Subject:</b> [Geomoose-users] Format numeric query result</span></div></div></div><div class="yiv506451733MsoNormal"> </div><div class="yiv506451733MsoNormal">I almost think this has been asked before, but can’t find anything in the archives. When I query or Identify a layer, the numeric results are in an exponential or scientific format (or whatever it’s called), and dates are in a yyyymmdd format. I’d like to format these results into something more user friendly. I’m looking at the Identify.php, but haven’t figured it out yet. Any suggestions? If it
makes a difference, the source data is shapefile, item types include double and date. It looks like long integer types format correctly in my output.</div></div></div></div><br>_______________________________________________<br>Geomoose-users mailing list<br><a ymailto="mailto:Geomoose-users@lists.osgeo.org" href="mailto:Geomoose-users@lists.osgeo.org">Geomoose-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/geomoose-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/geomoose-users</a><br><br><br> </div> </div> </blockquote></div> </div></body></html>