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

Calculate age in field calc using python parser

JustinNettleton

I am looking to calculate an Age field from a DOB field using the python Parser in Desktop field calculator. Does anyone know the syntax I would need to use?

Thanks,

Trouver plus de publications taguées avec

Accepted answers

achapkowski

Using the code box in field calculator, you can subtract two python datatime objects from each other.

For the code block use something like this:

def dateDiff(date):    from datetime import datetime    return int((datetime.now( ) - datetime.strptime(date,"%m/%d/%Y")).days/365.2425)

In the expression just enter in the name the following:

dateDiff( !DOB! )

Where field DOB is a date field.

All comments

Lucas Danzinger

If you are at 10.1, you can just test to see if a value is Null by checking to see if it equals None. This is highlighted in KB 40913.

You should be able to do something like:

def dateDiff(date):
   from datetime import datetime
   if date is None:
       pass
   else:
       return int((datetime.now( ) - datetime.strptime(date,"%m/%d/%Y")).days/365.2425)

DanielO_Donnell

This works very well, unless there is a NULL value in a record. Naturally, one doesn't always have a DOB for each record.

Any ideas?

I Add Field "Age", then Calculate Field using the above python algorythm... however, I get an error when it hits NULL values.

ERROR 000539:
Error running expression datediff ( " " ) <type 'exceptions.ValueError'>: time data ' ' does not match format '%Y%m%d'
Failed to execute (Calculate Field: AGE)

JustinNettleton

Thanks, works perfect.

achapkowski

Using the code box in field calculator, you can subtract two python datatime objects from each other.

For the code block use something like this:

def dateDiff(date):    from datetime import datetime    return int((datetime.now( ) - datetime.strptime(date,"%m/%d/%Y")).days/365.2425)

In the expression just enter in the name the following:

dateDiff( !DOB! )

Where field DOB is a date field.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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