I have a table (GIS Data) which contains a field called, "InstallDate." The field has date values ranging from "01-01-1930" to the current date.
There is a recently added field called, "InstallYr."
I need to update the "InstallYr" field based on the date in "InstallDate."
For example, if...