Calculating Quarter (Q1, Q2, etc) using Date field in ArcMap Field Calculator?

Question

I am using ArcMap 10.0 and making a map where I symbolize on annual quarter (i.e. Q1 2013, Q2 2013, and so on by quarter through 2015).

If a date field contains this: 01/15/2013, and I wanted to create a new field called QUARTER, that would contain the quarter in which the date falls, how could I do that?

Right now I'm just definition querying a range of dates, but surely there is a way to just calculate Quarter, right?

Answer 1

This python field calculator script should work:

def checkValue(field):
  myMonth = int(field.split('/')[0])
  myYear = field.split('/')[2]
  if myMonth <=3:
    return 'Q1-' + myYear
  elif myMonth >= 4 and myMonth <=6:
    return 'Q2-' + myYear
  elif myMonth >=7 and myMonth <=9:
    return 'Q3-' + myYear
  else:
    return 'Q4-' + myYear

Hope that helps.

Answer 2

Here's a way using integer division:

def checkValue(field):
    m,d,y=field.split('/') #assumes date in some backward MM/DD/YYYY format, what's with that? ;)
    q=(int(m)-1)//3 + 1
    return 'Q%s - %s'%(q,y)