topic Re: Labelling by Year from Date Field in Data Management Questions https://community.esri.com/t5/data-management-questions/labelling-by-year-from-date-field/m-p/290392#M16626 <HTML><HEAD></HEAD><BODY><SPAN>how do you do this but show it like this: </SPAN><BR /><SPAN>dd/mm/yyyy</SPAN><BR /><SPAN>e.g. 31/01/2013</SPAN><BR /><BR /><SPAN>thanks</SPAN></BODY></HTML> Wed, 03 Apr 2013 20:29:54 GMT FredMcDoddle 2013-04-03T20:29:54Z Labelling by Year from Date Field https://community.esri.com/t5/data-management-questions/labelling-by-year-from-date-field/m-p/290387#M16621 <HTML><HEAD></HEAD><BODY><SPAN>I need to label using only the year from the date field.&nbsp; How do I do this?&nbsp; Thanks!</SPAN><BR /><SPAN>I am using ArcView 9.3.</SPAN></BODY></HTML> Wed, 21 Mar 2012 13:06:32 GMT https://community.esri.com/t5/data-management-questions/labelling-by-year-from-date-field/m-p/290387#M16621 LindseyMitchener 2012-03-21T13:06:32Z Re: Labelling by Year from Date Field https://community.esri.com/t5/data-management-questions/labelling-by-year-from-date-field/m-p/290388#M16622 <HTML><HEAD></HEAD><BODY><SPAN>You can use this syntax where DATE_ is your date field:</SPAN><BR /><BR /><SPAN>DatePart("yyyy",[Date_])</SPAN></BODY></HTML> Wed, 21 Mar 2012 13:34:52 GMT https://community.esri.com/t5/data-management-questions/labelling-by-year-from-date-field/m-p/290388#M16622 KenBuja 2012-03-21T13:34:52Z Re: Labelling by Year from Date Field https://community.esri.com/t5/data-management-questions/labelling-by-year-from-date-field/m-p/290389#M16623 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote"> You can use this syntax where DATE_ is your date field:&nbsp; <BR /> <BR />DatePart("yyyy",[Date_])</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>Ken Buja is absolutely right ... <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN><BR /><BR /><SPAN>Right click on shape file in </SPAN><SPAN style="font-style:italic;"><STRONG>Table of contents</STRONG></SPAN><SPAN>, than </SPAN><STRONG style="font-style: italic;">Labels</STRONG><SPAN> Tab, than </SPAN><STRONG style="font-style: italic;">Text string</STRONG><SPAN> &gt; </SPAN><SPAN style="font-style:italic;"><STRONG>Button Expression</STRONG></SPAN><SPAN> than field </SPAN><STRONG style="font-style: italic;">Expression</STRONG><SPAN> and copy-paste code from kenbuja in text box, and replace </SPAN><SPAN style="color:&quot;#FF0000&quot;;">DATE_</SPAN><SPAN> with your data field name. (This is for ArcGis 10, but I assume that is same for previous 9.x versions, as I can remember ...)</SPAN></BODY></HTML> Wed, 21 Mar 2012 13:55:16 GMT https://community.esri.com/t5/data-management-questions/labelling-by-year-from-date-field/m-p/290389#M16623 UrosDjuric 2012-03-21T13:55:16Z Re: Labelling by Year from Date Field https://community.esri.com/t5/data-management-questions/labelling-by-year-from-date-field/m-p/290390#M16624 <HTML><HEAD></HEAD><BODY><SPAN>I am getting a Invalid procedure call/aargument using "DatePart"&nbsp;&nbsp; in the Field Calculator ArcGIS 10 SP3 XP&nbsp; FileGeodataBase Feature</SPAN><BR /><SPAN>DatePart("dd",&nbsp; [Date_Observed]).&nbsp; Date_Observed is a date field.&nbsp; The field I am calculating is text, long, date - I've tried all.&nbsp; I also tried DatePart("d",&nbsp; [Date_Observed]).&nbsp; I have used this successfully in 9.3.1.&nbsp; Any other options ?&nbsp; Anyone now the python equivalent??</SPAN></BODY></HTML> Thu, 05 Apr 2012 20:35:40 GMT https://community.esri.com/t5/data-management-questions/labelling-by-year-from-date-field/m-p/290390#M16624 DianeMcConnaughey 2012-04-05T20:35:40Z Re: Labelling by Year from Date Field https://community.esri.com/t5/data-management-questions/labelling-by-year-from-date-field/m-p/290391#M16625 <HTML><HEAD></HEAD><BODY><SPAN>DatePart ("d", [date] ) works for me, calculating a text field from a date field. Maybe double check that the date field is actually a date field, and not text disguised as a date...?</SPAN></BODY></HTML> Thu, 05 Apr 2012 20:43:04 GMT https://community.esri.com/t5/data-management-questions/labelling-by-year-from-date-field/m-p/290391#M16625 DarrenWiens2 2012-04-05T20:43:04Z Re: Labelling by Year from Date Field https://community.esri.com/t5/data-management-questions/labelling-by-year-from-date-field/m-p/290392#M16626 <HTML><HEAD></HEAD><BODY><SPAN>how do you do this but show it like this: </SPAN><BR /><SPAN>dd/mm/yyyy</SPAN><BR /><SPAN>e.g. 31/01/2013</SPAN><BR /><BR /><SPAN>thanks</SPAN></BODY></HTML> Wed, 03 Apr 2013 20:29:54 GMT https://community.esri.com/t5/data-management-questions/labelling-by-year-from-date-field/m-p/290392#M16626 FredMcDoddle 2013-04-03T20:29:54Z Re: Labelling by Year from Date Field https://community.esri.com/t5/data-management-questions/labelling-by-year-from-date-field/m-p/290393#M16627 <HTML><HEAD></HEAD><BODY><SPAN>Actually, I worked out a way. There might be a better way but this works:</SPAN><BR /><BR /><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro"> DatePart("d", [Sampled_Date_Time] )&nbsp; &amp; "/"&nbsp; &amp; DatePart("m", [Sampled_Date_Time] ) &amp; "/"&nbsp; &amp; DatePart("yyyy", [Sampled_Date_Time] ) </PRE><BR /><BR /><SPAN>see also:</SPAN><BR /><BR /><A href="http://msdn.microsoft.com/en-us/library/ms174420.aspx">http://msdn.microsoft.com/en-us/library/ms174420.aspx</A><BR /><BR /><SPAN>:cool:</SPAN></BODY></HTML> Wed, 03 Apr 2013 20:43:19 GMT https://community.esri.com/t5/data-management-questions/labelling-by-year-from-date-field/m-p/290393#M16627 FredMcDoddle 2013-04-03T20:43:19Z