nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

field calculating data from a short integer field to date field

ErikBlake

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)

what is the vb or python script to move the data over to the new field

Finde mehr Beiträge mit dem Tag

Accepted answers

TomSellsted

Erik,

You will need to include a month and a day to get a consistent date value.

vbScript:

"01/01/" & Yr_install

Regards,

Tom

All comments

TomSellsted

Erik,

You will need to include a month and a day to get a consistent date value.

vbScript:

"01/01/" & Yr_install

Regards,

Tom

ErikBlake

Tom

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

TomSellsted

Erik,

If you don't have a specific month and day for them, you can just set them all to January 1st for that year. When you are display the dates anywhere you can just display the year. It might be best to just keep the field as an integer if you are only concerned with the year.

Regards,

Tom

ErikBlake

Tom

Thanks. The only reason i am doing this is cause I want to test 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

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.