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; } } }

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

RobBlash

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!

GetYearPython.png

machine2.png

PhilLarkin1_0-1621616059298.png

Encontre mais publicações marcadas com

Accepted answers

All comments

TomyArdyansyah

thank you, it work on my case

SanjaySinghNegi

!installdate!.year

FernandoAlvarez1

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

DanPatterson_Retired

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

RobBlash

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.

RobBlash

Makes sense, thanks for the tip.

JoshuaBixby

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.

JoshuaBixby

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.

blake.terhune

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!

RobBlash

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.

RobBlash

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

WesMiller

JoshuaBixby

Try this:

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

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

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