I have two date fields dd.mm.yyyy with a start and an end date in my attribute table. Now I want only to extract the years from these fields to new fields. So I created another field, and used
year_start_date = DatePart ( "YYYY", [Start_date] ) in the field calculator.
But the result is a complete date (dd.mm.yyyy) more than 100 years ago.
Just to test, I created a new field and added with the function
Now() the actual date (13.05.2014) and tried again to use
year_start_date = DatePart ( "YYYY", [Start_date] ) and I got "06.07.1905" as a result.
What am I doing wrong? Is there another way to do this? I use ArcGIS 10.2.