<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=utf-8">
<meta name="Generator" content="Microsoft Word 15 (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:"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:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle22
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.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 lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word"><table bgcolor="#F5F2AC">
<tbody>
<tr>
<td><center><strong><span style="color: #ff0000;">EXTERNAL MESSAGE</span><br></strong>This email originated outside of DEP. Please use caution when opening attachments, clicking links, or responding to this email.</center></td>
</tr>
</tbody>
</table>
<div class="WordSection1">
<p class="MsoNormal">Good Afternoon Scott,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I’ve attached a getYear calc expression you can import to the field calculator. Just change the field from ‘today’ to wherever you have your date.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">This assumes the date look like this<i>: 11/15/2021 2:18:15 PM
</i><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">If you do not have a timestamp, just the date, change this portion of the code:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:1.0in;text-indent:.5in"><i>dt = today.split(' ')[0]
<o:p></o:p></i></p>
<p class="MsoNormal" style="margin-left:1.5in;text-indent:.5in"><b>to</b> <br>
<i>dt = today<o:p></o:p></i></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">if your dates are arranged differently, change the highlighted<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><i><span style="background:yellow;mso-highlight:yellow">month, day, year</span></i><i> = (int(x) for x in dt.split('/'))<o:p></o:p></i></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">You can email me if you have any issues with the code or need help
<span style="font-family:"Segoe UI Emoji",sans-serif">😊</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#0070C0">Janelle Versnick, GISP<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:gray">GIS Team Leader<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:gray">Technology Group</span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#7F7F7F">Direct</span></b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#7F7F7F"> (850) 536-8522
<b>Cell </b>(850) 879-2374 <b>Tallahassee Office </b>(850) 878-9777<b> </b><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#0D0D0D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">HNTB CORPORATION<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#7F7F7F">1276 Metropolitan Blvd, Suite 304, Tallahassee, FL, 32312 |</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:gray">
</span><a href="http://www.hntb.com/"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:gray">www.hntb.com</span></a><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#7F7F7F">
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:24.0pt;font-family:"Arial",sans-serif;color:#F9461C">■</span><b><span style="font-family:"Arial",sans-serif;color:black"> 100+ YEARS OF INFRASTRUCTURE SOLUTIONS</span></b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#7F7F7F"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:black"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><a href="https://twitter.com/HNTBCorp" target="_blank"><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:#4D8AC0;text-decoration:none"><img border="0" width="18" height="17" style="width:.1916in;height:.175in" id="Picture_x0020_8" src="cid:image008.jpg@01D7DA2C.48673AE0"></span></a><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:#676767"> </span><a href="https://www.youtube.com/user/hntbcorp?feature=results_main" target="_blank"><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:#4D8AC0;text-decoration:none"><img border="0" width="18" height="17" style="width:.1916in;height:.175in" id="Picture_x0020_9" src="cid:image009.png@01D7DA2C.48673AE0"></span></a><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:#676767"> </span><a href="http://www.linkedin.com/company/hntb?trk=tyah" target="_blank"><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:#4D8AC0;text-decoration:none"><img border="0" width="17" height="17" style="width:.175in;height:.175in" id="Picture_x0020_10" src="cid:image010.jpg@01D7DA2C.48673AE0"></span></a><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:#676767"> </span><a href="https://www.facebook.com/HNTBCorp" target="_blank"><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:#4D8AC0;text-decoration:none"><img border="0" width="17" height="17" style="width:.175in;height:.175in" id="Picture_x0020_11" src="cid:image011.png@01D7DA2C.48673AE0"></span></a><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:#676767"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> SHRUG-L <shrug-l-bounces@lists.dep.state.fl.us>
<b>On Behalf Of </b>Scott Crosby<br>
<b>Sent:</b> Monday, November 15, 2021 2:03 PM<br>
<b>To:</b> SHRUG-L@lists.dep.state.fl.us<br>
<b>Subject:</b> shrug-l: Extracting the year out of a date field and inputting that value in an Origin year field<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" style="background:#F5F2AC">
<tbody>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal" align="center" style="text-align:center"><strong><span style="font-family:"Calibri",sans-serif;color:red">EXTERNAL MESSAGE</span></strong><b><span style="color:black"><br>
</span></b><span style="color:black">This email originated outside of DEP. Please use caution when opening attachments, clicking links, or responding to this email.</span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal">Hi all,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I’m working with a timber stand layer and need to extract the year out of an Establishment date field (type is date) and input that value in an Origin year field (type is short integer). I see where there is an option in Field Calculator
to calculate dates, but it appears that this can’t be done in Field Calculator (I’ve tried several different times, but no success). Has someone written a python script that will do this extraction and input that value as a short integer into another field,
or is there a tool in Arc Toolbox that will do this?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" width="668" style="width:501.0pt">
<tbody>
<tr style="height:18.75pt">
<td width="108" style="width:81.0pt;padding:.75pt .75pt .75pt .75pt;height:18.75pt">
<p class="MsoNormal"><a href="http://www.alachuacounty.us/Pages/AlachuaCounty.aspx" title="Alachua County Fire Rescue website"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;text-decoration:none"><img border="0" width="100" height="100" style="width:1.0416in;height:1.0416in" id="Picture_x0020_1" src="cid:image001.png@01D7DA2B.CF523880"></span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
</td>
<td width="551" style="width:413.25pt;padding:.75pt .75pt .75pt .75pt;height:18.75pt">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Scott Crosby, SAF Certified Forester
</span></b><span style="font-size:8.0pt;font-family:"Arial",sans-serif"><br>
Senior Environmental Specialist<br>
Land Conservation and Management<br>
408 W. University Ave Suite 106 • Gainesville • FL • 32601<br>
352-264-6823 (office) • 352-213-0024 (mobile)<br>
</span><a href="http://www.alachuacounty.us/Pages/AlachuaCounty.aspx"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;text-decoration:none"><img border="0" width="28" height="35" style="width:.2916in;height:.3666in" id="Picture_x0020_2" src="cid:image002.png@01D7DA2B.CF523880"></span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif"> </span><a href="https://www.facebook.com/AlachuaCounty/"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;text-decoration:none"><img border="0" width="28" height="28" style="width:.2916in;height:.2916in" id="Picture_x0020_3" src="cid:image003.png@01D7DA2B.CF523880"></span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif"> </span><a href="https://twitter.com/alachuacounty"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;text-decoration:none"><img border="0" width="28" height="28" style="width:.2916in;height:.2916in" id="Picture_x0020_4" src="cid:image004.png@01D7DA2B.CF523880"></span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif"> </span><a href="https://www.instagram.com/alachuacounty/"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;text-decoration:none"><img border="0" width="28" height="28" style="width:.2916in;height:.2916in" id="Picture_x0020_5" src="cid:image005.png@01D7DA2B.CF523880"></span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif"> </span><a href="https://www.youtube.com/user/alachuacounty"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;text-decoration:none"><img border="0" width="28" height="28" style="width:.2916in;height:.2916in" id="Picture_x0020_6" src="cid:image006.png@01D7DA2B.CF523880"></span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif">
</span><a href="http://www.alachuacounty.us/depts/communications/pages/updatenewsletter.aspx"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;text-decoration:none"><img border="0" width="28" height="28" style="width:.2916in;height:.2916in" id="Picture_x0020_7" src="cid:image007.png@01D7DA2B.CF523880"></span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
</td>
</tr>
<tr style="height:18.75pt">
<td colspan="2" valign="top" style="padding:.75pt .75pt .75pt .75pt;height:18.75pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:8.0pt;font-family:"Arial",sans-serif">PLEASE NOTE: Florida has a very broad public records law (F.S.119).<br>
All e-mails to and from County Officials and County Staff are kept as public records. Your e-mail
<br>
communications, including your e-mail address, may be disclosed to the public and media at any time.<br>
..</span><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div><em><font style="FONT-FAMILY: ; FONT-SIZE: 11px"><span style="FONT-FAMILY: 'arial', 'sans-serif'; FONT-SIZE: 10pt">This
e-mail and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to whom they are
addressed.<span> </span>If you are NOT the intended recipient and receive this communication, please delete this message and any attachments. Thank you.</span></font></em></body>
</html>