<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:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" 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)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"MS Gothic";
panose-1:2 11 6 9 7 2 5 8 2 4;}
@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:"\@MS Gothic";
panose-1:2 11 6 9 7 2 5 8 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@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 lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Hi All,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The suggestions I received for the max date query got me a little closer, but I got some crazy results. In the short term, I decided to just weed through it manually. I’ll revisit it when I have more time. Thanks, again!<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div style='margin-bottom:10.0pt'><div class=MsoNormal><hr size=2 width="100%" noshade style='color:#008264' align=left></div></div><p class=MsoNormal style='margin-bottom:10.0pt'><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:teal'>Jim Thomas, GISP</span></b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'> | GIS Analyst | </span><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:teal'>Golder Associates Inc.</span></b><b><span style='font-size:10.0pt;color:teal'> <br></span></b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>9428 Baymeadows Road, Suite 400, Jacksonville, Florida, USA 32256</span><span style='font-size:10.0pt;color:black'> <br></span><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:teal'>T: </span></b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>+1 (904) 363-3430 | </span><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:teal'>F: </span></b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>+1 (904) 363-3445 | </span><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:teal'>E: </span></b><a name=email></a><a href="mailto:jim_thomas@golder.com"><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>jim_thomas@golder.com</span></a><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'> | <a name=web></a><a href="http://www.golder.com/"><b><span style='color:black'>www.golder.com</span></b></a></span><b><span style='font-size:10.0pt;color:black'> <br></span></b><br><b><i><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:teal'>Work Safe, Home Safe</span></i></b><b><i><span style='font-size:10.0pt;color:teal'> <br></span></i></b><br><i><span style='font-size:7.5pt;font-family:"Arial","sans-serif";color:gray'>This email transmission is confidential and may contain proprietary information for the exclusive use of the intended recipient. Any use, distribution or copying of this transmission, other than by the intended recipient, is strictly prohibited. If you are not the intended recipient, please notify the sender and delete all copies. Electronic media is susceptible to unauthorized modification, deterioration, and incompatibility. Accordingly, the electronic media version of any work product may not be relied upon.</span></i><span style='font-size:7.5pt;color:gray'> <br></span><br><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:gray'>Please consider the environment before printing this email.</span></b><span style='font-size:10.0pt;color:gray'> </span><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>