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

How to extract month from mm/dd/yyyy date field in ArcGIS Pro?

ChrisSpadi1

I have an attribute table with an ALARM_DATE field (mm/dd/yyyy) (data type: Date) and I want to extract only the month from it to a new field.

What is the simplest way to achieve this in field calculator or python 3?

ESRI_Extract.PNG

july-25-training-news-1200x600-mars-with-copy.jpg

Find more posts tagged with

Accepted answers

ChrisSpadi1

Thanks everyone. I ended up figuring it out with an Arcade solution using the date function Month.

date field is !ALARM_DATE!

new field I want only the month number is !Month_!

All you need to do is use the field calculator for new field ----> !Month_! (integer)

Choose Arcade, enter Month($feature.ALARM_DATE), this returns values of the month 0 - 11 in Month_ field.

Use field calculator again on !Month_! with Python to add 1 to make it 1-12, -----> !Month_! + 1

All comments

DanPatterson_Retired

An example of a time field in a table called Timetest (python parser)

int<SPAN class="punctuation token">(</SPAN>!Timetest!<SPAN class="punctuation token">.</SPAN>month<SPAN class="punctuation token">)</SPAN>‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Now via example

n <SPAN class="operator token">=</SPAN> datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">.</SPAN>now<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

n
datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">(</SPAN><SPAN class="number token">2018</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">12</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">15</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">20</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">11</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">32</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">784152</SPAN><SPAN class="punctuation token">)</SPAN>

type<SPAN class="punctuation token">(</SPAN>n<SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token"><</SPAN><SPAN class="keyword token">class</SPAN> <SPAN class="string token">'datetime.datetime'</SPAN><SPAN class="operator token">></SPAN>

dir<SPAN class="punctuation token">(</SPAN>n<SPAN class="punctuation token">)</SPAN>

<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> snip<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'astimezone'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'combine'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ctime'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'date'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'day'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'dst'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'fold'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'fromordinal'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'fromtimestamp'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'hour'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'isocalendar'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'isoformat'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'isoweekday'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'max'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'microsecond'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'min'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'minute'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'month'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'now'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'replace'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'resolution'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'second'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'strftime'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'strptime'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'time'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'timestamp'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'timetuple'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'timetz'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'today'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'toordinal'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'tzinfo'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'tzname'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'utcfromtimestamp'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'utcnow'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'utcoffset'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'utctimetuple'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'weekday'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'year'</SPAN><SPAN class="punctuation token">]</SPAN>

n<SPAN class="punctuation token">.</SPAN>month&nbsp; <SPAN class="comment token"># ---- which is now an integer</SPAN>
<SPAN class="number token">12</SPAN>

<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

shan_sarkar

Have you tried using the Left () available in the Field Calculator under the String() tab?

How to extract Middle, Left, or Right characters in Calculate Field tool

Calculate Field Python examples—Data Management toolbox | ArcGIS Desktop

ChrisSpadi1

Thanks everyone. I ended up figuring it out with an Arcade solution using the date function Month.

date field is !ALARM_DATE!

new field I want only the month number is !Month_!

All you need to do is use the field calculator for new field ----> !Month_! (integer)

Choose Arcade, enter Month($feature.ALARM_DATE), this returns values of the month 0 - 11 in Month_ field.

Use field calculator again on !Month_! with Python to add 1 to make it 1-12, -----> !Month_! + 1

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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