arcgis-10.2arcgis-desktopdatelabeling
I was hoping someone could help me with this. I know this is probably easy but I am still new to ArcMap.
I need to label pipe mains with the year installed but my attributes have the entire date. How can I format the label to only display the year (yyyy)? I am using ArcMap 10.2.2 and VBScript. I have included screenshots to show where I am at currently.
GP cursors read date values as datetime objects, so you can use datetime.strftime() to format it as you like, or datetime.ctime() to format it as the default format (%a %b %d %H:%M:%S %Y).
Here's an example using mm/dd/yyyy:
import arcpy
from datetime import datetime
fc = r"C:\GISData\test.gdb\atlantic_hurricanes_2000"
rows = arcpy.SearchCursor(fc)
for row in rows:
datetimeVal = row.getValue("Date_Time")
formattedTime = datetime.strftime(datetimeVal, "%m/%d/%Y")
print formattedTime
For the meanings of the various time formatting codes see strftime behavior.
There are links to each language Reference pages at the bottom of this esri help page.
If you are writing a function you should check the advanced box and as described write in the selected language of the parser (below).
Best Answer
You should be able to use the Year function directly in your label expression: