topic Re: field calculating data from a short integer field to date field in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/field-calculating-data-from-a-short-integer-field/m-p/106709#M4140 <HTML><HEAD></HEAD><BODY><P>Erik,</P><P></P><P>You will need to include a month and a day to get a consistent date value.</P><P></P><P>vbScript:</P><P></P><P>"01/01/" &amp; Yr_install</P><P></P><P>Regards,</P><P></P><P>Tom</P></BODY></HTML> Tue, 10 Feb 2015 20:05:41 GMT TomSellsted 2015-02-10T20:05:41Z field calculating data from a short integer field to date field https://community.esri.com/t5/arcgis-enterprise-questions/field-calculating-data-from-a-short-integer-field/m-p/106708#M4139 <HTML><HEAD></HEAD><BODY><P>I am trying to calculate our values from one field called Yr_Install which is a short integer. to a new field called Year_Install which I created and made it a Date data type. When I try to field calculate the values from the short integer field which has the values 1968, 1914, 2014,2012 etc into the new year installed field all it does is populate the field with some random date and 1905 for all values.( i.e 6/8/1905)</P><P></P><P>what is the vb or python script to move the data over to the new field</P></BODY></HTML> Tue, 10 Feb 2015 19:56:16 GMT https://community.esri.com/t5/arcgis-enterprise-questions/field-calculating-data-from-a-short-integer-field/m-p/106708#M4139 ErikBlake 2015-02-10T19:56:16Z Re: field calculating data from a short integer field to date field https://community.esri.com/t5/arcgis-enterprise-questions/field-calculating-data-from-a-short-integer-field/m-p/106709#M4140 <HTML><HEAD></HEAD><BODY><P>Erik,</P><P></P><P>You will need to include a month and a day to get a consistent date value.</P><P></P><P>vbScript:</P><P></P><P>"01/01/" &amp; Yr_install</P><P></P><P>Regards,</P><P></P><P>Tom</P></BODY></HTML> Tue, 10 Feb 2015 20:05:41 GMT https://community.esri.com/t5/arcgis-enterprise-questions/field-calculating-data-from-a-short-integer-field/m-p/106709#M4140 TomSellsted 2015-02-10T20:05:41Z Re: field calculating data from a short integer field to date field https://community.esri.com/t5/arcgis-enterprise-questions/field-calculating-data-from-a-short-integer-field/m-p/106710#M4141 <HTML><HEAD></HEAD><BODY><P>Tom</P><P>Thanks for the help. We never kept day and month we were just concerned with the year. Is there anyway around that or do I have to just create a generic day and month for all the features</P></BODY></HTML> Tue, 10 Feb 2015 22:41:54 GMT https://community.esri.com/t5/arcgis-enterprise-questions/field-calculating-data-from-a-short-integer-field/m-p/106710#M4141 ErikBlake 2015-02-10T22:41:54Z Re: field calculating data from a short integer field to date field https://community.esri.com/t5/arcgis-enterprise-questions/field-calculating-data-from-a-short-integer-field/m-p/106711#M4142 <HTML><HEAD></HEAD><BODY><P>Erik,</P><P></P><P>If you don't have a specific month and day for them, you can just set them all to January 1st for that year.&nbsp; When you are display the dates anywhere you can just display the year.&nbsp; It might be best to just keep the field as an integer if you are only concerned with the year.</P><P></P><P>Regards,</P><P></P><P>Tom</P></BODY></HTML> Tue, 10 Feb 2015 22:53:30 GMT https://community.esri.com/t5/arcgis-enterprise-questions/field-calculating-data-from-a-short-integer-field/m-p/106711#M4142 TomSellsted 2015-02-10T22:53:30Z Re: field calculating data from a short integer field to date field https://community.esri.com/t5/arcgis-enterprise-questions/field-calculating-data-from-a-short-integer-field/m-p/106712#M4143 <HTML><HEAD></HEAD><BODY><P>Tom</P><P>Thanks. The only reason i am doing this is cause I want to test&nbsp; out the LGIM and in order to import my data into the models schema I need to make sure that data types match for corresponding fields and the model has their year installed field as date. But maybe I will just make everything janurary like you suggested. Thanks</P></BODY></HTML> Tue, 10 Feb 2015 23:00:49 GMT https://community.esri.com/t5/arcgis-enterprise-questions/field-calculating-data-from-a-short-integer-field/m-p/106712#M4143 ErikBlake 2015-02-10T23:00:49Z Re: field calculating data from a short integer field to date field https://community.esri.com/t5/arcgis-enterprise-questions/field-calculating-data-from-a-short-integer-field/m-p/106713#M4144 <HTML><HEAD></HEAD><BODY><P>Erik,</P><P></P><P>You are welcome!</P><P></P><P>Regards,</P><P></P><P>Tom</P></BODY></HTML> Tue, 10 Feb 2015 23:12:19 GMT https://community.esri.com/t5/arcgis-enterprise-questions/field-calculating-data-from-a-short-integer-field/m-p/106713#M4144 TomSellsted 2015-02-10T23:12:19Z