<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto">We have used the date convention yyyymmdd which is numeric and easily range searchable. Uncertainty can be accommodated using zeros, so March 1984 would be 19840300; 1984 with no further date is 19840000. More indefinite dates are harder to handle numerically. <br><br><div id="AppleMailSignature">Sent from my iPhone</div><div><br>On Sep 17, 2018, at 9:21 PM, Schultz, Eric <<a href="mailto:eric.schultz@uconn.edu">eric.schultz@uconn.edu</a>> wrote:<br><br></div><blockquote type="cite"><div>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (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;}
/* 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:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@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]-->
<div class="WordSection1">
<p class="MsoNormal">We are cleaning up entries in a legacy database so that our data can be imported into a properly configured collections database. Exact dates will be imported in a text string mm/dd/yyyy. But how to render a vague date referring only
to season, such as ‘Spring 1984’, or if only the year was recorded? Is it better to record as missing data, record as an erroneous but exact date such as 01/01/1984, or place at the midpoint of the season? Whatever we do we will have a ‘verbatim’ field that
preserves the original entry, but we want to have a version of collection date that is useful and searchable. Thanks for any assistance!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Eric T. Schultz<o:p></o:p></p>
<p class="MsoNormal">Professor, Department of Ecology and Evolutionary Biology<o:p></o:p></p>
<p class="MsoNormal">Coordinator, Joint BS-MS Degree in Biodiversity and Conservation Biology<o:p></o:p></p>
<p class="MsoNormal">Director, Vertebrate Biodiversity Collections<o:p></o:p></p>
<p class="MsoNormal">Chair, General Education Oversight Committee<o:p></o:p></p>
<p class="MsoNormal">University of Connecticut<o:p></o:p></p>
<p class="MsoNormal">Storrs, CT 06269-3043<o:p></o:p></p>
<p class="MsoNormal"><a href="mailto:eric.schultz@uconn.edu">eric.schultz@uconn.edu</a><o:p></o:p></p>
<p class="MsoNormal">860.486.4692<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>Nhcoll-l mailing list</span><br><span><a href="mailto:Nhcoll-l@mailman.yale.edu">Nhcoll-l@mailman.yale.edu</a></span><br><span><a href="https://mailman.yale.edu/mailman/listinfo/nhcoll-l">https://mailman.yale.edu/mailman/listinfo/nhcoll-l</a></span><br><span></span><br><span>_______________________________________________</span><br><span>NHCOLL-L is brought to you by the Society for the Preservation of</span><br><span>Natural History Collections (SPNHC), an international society whose</span><br><span>mission is to improve the preservation, conservation and management of</span><br><span>natural history collections to ensure their continuing value to</span><br><span>society. See <a href="http://www.spnhc.org">http://www.spnhc.org</a> for membership information.</span><br><span>Advertising on NH-COLL-L is inappropriate.</span><br></div></blockquote></body></html>