topic Re: Labeling with Dates in Python Questions

Labeling with Dates

NicholasGlover — Tue, 21 Jan 2014 18:29:41 GMT

Hello everyone,

I'm trying to label a feature class that has a date field in it. My problem is that I only want to get the mm/dd/yyyy, but when I try to label it through python it will bring up the time as well. I tried using an array on dateOff (the date field), but I still run into the issue of it grabbing part of the time. My question is, what do I need to do in my python script to only get the date information and not the time information to show up in my label.

Here is a sample of what I have done so far.

import os  def FindLabel ( [Cause_Of_Outage] , [Date_Off] ):   outageType = [Cause_Of_Outage]    dateOff = [Date_Off]    return 'Outage Type: ' + outageType + os.linesep +'Date Off: ' + dateOff[0:10]

Re: Labeling with Dates

JoshuaChisholm — Tue, 21 Jan 2014 19:05:49 GMT

Good day Nicholas,

As far as I know arcmap stores only date objects (without time). For this reason, I suspect the DateOff is a string field (which is why you're using the array on it).

If there is a space in between the year and the time, you can split your string using that space and take the first part (see below).

You may also want to use "/n" instead of os.linesep (at your discretion).

def FindLabel ( [Cause_Of_Outage] , [Date_Off] ):   outageType = [Cause_Of_Outage]    dateOff = [Date_Off].split(" ")[0]   return 'Outage Type: ' + outageType + '\nDate Off: ' + dateOff

Good luck, hope it works out!

Re: Labeling with Dates

NicholasGlover — Tue, 21 Jan 2014 19:29:32 GMT

That seemed to do it Joshua! Thanks!