topic Re: how do I change date format in labels in New to GIS Questions

how do I change date format in labels

JamesHarrington — Mon, 15 Sep 2014 18:42:26 GMT

Hello,

I want to label point features with a date field. The labels show long date and time. I do not want to show the time, just the date. Is there a way to format the label to show only the date?

Re: how do I change date format in labels

DarrenWiens2 — Mon, 15 Sep 2014 23:39:10 GMT

You can change date label format in the label expression.

VBScript:

DateValue([date])

Here are the VBScript Date functions.

Likewise, search for Python date functions.

Re: how do I change date format in labels

OwenEarley — Mon, 15 Sep 2014 23:45:56 GMT

Hi James,

You can use a python function for the label expression to change your date format. Click on the Expression button on the Label properties then:

Select your date field.
Check the Advanced option
Change the Parser option to Python
Copy and paste the python function (below) into the expression
Change the input datetime format if required (in the example this is '%d/%m/%Y %H:%M:%S %p')
Change the output format if required (in the example this is '%d, %b %Y')
Click Verify to test and OK to apply

Python function for the label expression:

from datetime import datetime
def FindLabel ( [TestDate] ):
  d = datetime.strptime([TestDate], '%d/%m/%Y %H:%M:%S %p')
  return d.strftime('%d, %b %Y')

A list of format strings is available here:

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

Hope this helps.

Owen

Spatial XP

Re: how do I change date format in labels

JamesHarrington — Tue, 28 Oct 2014 15:42:23 GMT

Unfortunately, I have some dates with times, some without. None of these solutions work without writing a much more complex script to identify the format. This is much too complicated. Why can't it recognize what format, and allow us the option to display it in whatever format we choose?

Re: how do I change date format in labels

JasonBalmut — Thu, 23 Jul 2015 14:58:29 GMT

Let's say I take a date field which has values like: 7/23/2015 7:00:00 AM. When I use the VB function TIMEVALUE to label the field it returns 7:00:00 AM.

If I want it to return 7 AM, how do I format the VB line?

Re: how do I change date format in labels

SepheFox — Thu, 23 Jul 2015 16:54:28 GMT

You can find a list of time format tags here: ArcGIS Help 10.1. Essentially, you would use the tag, format= "h tt".

Re: how do I change date format in labels

BrandonLee1 — Thu, 24 Jan 2019 19:50:09 GMT

I have the same question regarding displaying only the month and day of the date.

This is a snip of the date field in ArcMap

I've tried this code:

from datetime import datetime
def FindLabel ( [StartDate] 😞
d = datetime.strptime([StartDate], '%m/%d/%Y %I:%M:%S %p')
return d.strftime('%d %m')

This is the error I am getting when I verify the expression. I read this so I know that the zero-padded date is not an issue..

Any insight on why the error is showing?