topic Re: Need help getting year from a date field (field calculator) in Python Questions

Need help getting year from a date field (field calculator)

RobBlash — Sat, 11 Dec 2021 13:11:02 GMT

I have dates (in a date field) of mixed formatting (1/21/2006 4:19:20 AM, 12/27/2007, etc.). I need to populate an integer field with just the year.

Based on this thread I'm trying to work my way through it but I can't get it figured out

d = datetime.datetime.strptime(!InstallDate!, "%d/%m/%Y")
justyr = datetime.datetime(d.year)

Any help would be appreciated!

Re: Need help getting year from a date field (field calculator)

JoshuaBixby — Fri, 03 Jun 2016 13:49:19 GMT

Try this:

arcpy.time.FormatDate( !InstallDate!, 'yyyy')

Re: Need help getting year from a date field (field calculator)

WesMiller — Fri, 03 Jun 2016 13:54:16 GMT

Re: Need help getting year from a date field (field calculator)

RobBlash — Fri, 03 Jun 2016 14:02:30 GMT

Thanks, not sure why this was impossible to find (I searched and searched....).

Re: Need help getting year from a date field (field calculator)

RobBlash — Fri, 03 Jun 2016 14:05:09 GMT

Thanks! Looks like dateutil has a lot of useful functions, which I'm sure will be helpful as I learn more python and tackle more complex problems.

Re: Need help getting year from a date field (field calculator)

BlakeTerhune — Fri, 03 Jun 2016 17:36:13 GMT

I didn't know arcpy had its own time. Put on your parachute pants and get ready for Esri Time! a parady of Hammer Time!

Re: Need help getting year from a date field (field calculator)

JoshuaBixby — Fri, 03 Jun 2016 18:44:29 GMT

The ArcPy Time module is odd in that most of its functionality isn't documented at all, like the FormatDate method that has no references in the Desktop documentation except one to the old AML FORMATDATE function.

Re: Need help getting year from a date field (field calculator)

JoshuaBixby — Fri, 03 Jun 2016 18:46:07 GMT

Robert Blash, this "question" was created as a Discussion instead of a Question. For future reference, it is best to mark questions as questions so people know you are seeking help instead of just sharing information.

Re: Need help getting year from a date field (field calculator)

RobBlash — Fri, 03 Jun 2016 18:51:57 GMT

Makes sense, thanks for the tip.

Re: Need help getting year from a date field (field calculator)

RobBlash — Fri, 03 Jun 2016 19:02:56 GMT

Thanks for mentioning this. I had found the documentation page you linked above, and I wondered why there wasn't a reference to .FormatDate()

How would you grade arcpy documentation overall? While I'm learning more and more about python I anticipate some head scratching along the way, which is of course minimized by good documentation. However, I didn't anticipate struggling so much to find this particular solution, after all finding DatePart('yyyy',[DateField]) is so much easier. I'm interested to hear the opinion of someone experienced.

Re: Need help getting year from a date field (field calculator)

DanPatterson_Retired — Fri, 03 Jun 2016 19:04:02 GMT

lurking behind the time stuff... is the fact that esri hasn't move from python 2 to python 3 completely... so little things like time zone had to be added to the arcpy stuff. However, when one makes the move, all will be good because it has been there for a while

So if you aren't ready... python 2.7 countdown...

then you might want to look at this

8.1. datetime — Basic date and time types — Python 3.5.1 documentation

don't let time go by

Re: Need help getting year from a date field (field calculator)

JoshuaBixby — Fri, 03 Jun 2016 19:48:53 GMT

I would rate the Python/ArcPy documentation as good, reaching towards very good. The documentation is constantly improving, although different parts improve at different paces since different development teams work on their own Python documentation.

Re: Need help getting year from a date field (field calculator)

FernandoAlvarez1 — Fri, 10 Aug 2018 19:00:59 GMT

This was very helpful, the code allows you to replace 'yyyy' with "dddd" and "MMMM" to return days and months in string formats

Re: Need help getting year from a date field (field calculator)

SanjaySinghNegi — Tue, 09 Apr 2024 20:29:53 GMT

!installdate!.year

Re: Need help getting year from a date field (field calculator)

TomyArdyansyah — Tue, 07 May 2024 09:03:45 GMT

thank you, it work on my case