topic Extract integer value of current year in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/extract-integer-value-of-current-year/m-p/876235#M29358 <HTML><HEAD></HEAD><BODY><P>I'm wondering if it's possible to the current year (e.g. 2018) and convert it to integer within a XLSForm.</P><P>I'm trying to extract the Year Date, send it to a number value and then do additional calucations and functions to the value for other fields.</P><P></P><P>Something like the following:</P><P><EM style="font-size: 12.0pt;">{<SPAN style="background: aqua;">Current Year</SPAN>} = Int(Year(Today()))</EM></P><P>&nbsp;</P><P></P><P>Thanks,</P><P></P><P>Adam Munro</P></BODY></HTML> Thu, 11 Oct 2018 15:49:49 GMT AdamMunro 2018-10-11T15:49:49Z Extract integer value of current year https://community.esri.com/t5/arcgis-survey123-questions/extract-integer-value-of-current-year/m-p/876235#M29358 <HTML><HEAD></HEAD><BODY><P>I'm wondering if it's possible to the current year (e.g. 2018) and convert it to integer within a XLSForm.</P><P>I'm trying to extract the Year Date, send it to a number value and then do additional calucations and functions to the value for other fields.</P><P></P><P>Something like the following:</P><P><EM style="font-size: 12.0pt;">{<SPAN style="background: aqua;">Current Year</SPAN>} = Int(Year(Today()))</EM></P><P>&nbsp;</P><P></P><P>Thanks,</P><P></P><P>Adam Munro</P></BODY></HTML> Thu, 11 Oct 2018 15:49:49 GMT https://community.esri.com/t5/arcgis-survey123-questions/extract-integer-value-of-current-year/m-p/876235#M29358 AdamMunro 2018-10-11T15:49:49Z Re: Extract integer value of current year https://community.esri.com/t5/arcgis-survey123-questions/extract-integer-value-of-current-year/m-p/876236#M29359 <HTML><HEAD></HEAD><BODY><P>format-date(today(),'%Y')</P><P>More details about formatting date objects:<A href="https://community.esri.com/groups/survey123/blog/2016/04/17/dates-and-time-in-survey123-for-arcgis">https://community.esri.com/groups/survey123/blog/2016/04/17/dates-and-time-in-survey123-for-arcgis</A>&nbsp; and <A class="link-titled" href="https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_DB5A29AC645F4AE585D7CEA9E6D5A36B" title="https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_DB5A29AC645F4AE585D7CEA9E6D5A36B">Formulas—Survey123 for ArcGIS | ArcGIS</A>&nbsp;</P></BODY></HTML> Thu, 11 Oct 2018 16:15:27 GMT https://community.esri.com/t5/arcgis-survey123-questions/extract-integer-value-of-current-year/m-p/876236#M29359 IsmaelChivite 2018-10-11T16:15:27Z