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 calculate a person's age from DOB value with Scripted field

Philemon Nkafu

I have a requirement to automatically calculate a person's age based on the value of entered in the DOB field. Am very new to scripting but have tried the below script to no success, It is not returning the person's age. I used the ScriptRunner scripted field and my selected template is "Date Time" and my searcher is "Date Time Picker Range" Please, I need some help

import com.atlassian.jira.component.ComponentAccessor
import java.time.Period
import java.time.LocalDate
import java.time.ZoneId

def customFieldManager = ComponentAccessor.customFieldManager
def dob = customFieldManager.getCustomFieldObjectsByName("DOB")[0]
def dobValue = dob.getValue(issue) as Date

static def convertToLocalDateViaInstant(Date dateToConvert) {
return dateToConvert.toInstant()
.atZone(ZoneId.systemDefault())
.toLocalDate()
}

def today = LocalDate.now()
def birthday = convertToLocalDateViaInstant(dobValue) as LocalDate

def age = Period.between(birthday, today)

return String.format("%d years, %d months, %d days", age.getYears(), age.getMonths(), age.getDays())

Accepted answers

All comments

Nic Brough -Adaptavist-

Why are you using a date-time template? Your script is returning a string, not a date.

Also, how are you triggering the recalculation you need to do every year?

Philemon Nkafu

@Nic Brough -Adaptavist-

Appreciate the identification of the template error. However, upon testing, I realized I may need some further help.

1. Am seeing NULL pointer exception error in the log, it has to do with the DOB field being empty in some tickets. Am thinking of a line like below but not sure. Please can you help with providing the line

If the DOB field is empty ignore it
if (DOBValue==null) {
return null
}

2. Also, can you help me with the line(s) for the recalculation?

3. As you can see, am returning year, month & day, how do I return only Year?

4. I would also like to have the script return the age for all DOB entered for projects in the database

Thanks for all your help.

Nic Brough -Adaptavist-

It's not great to compare to null, you can just say "if there is a value" or "if there is no value" - in this case you can say the second with "if (!DOBValue) "
Where are you stuck on it?
If you want just the year, then change your script to only return the year, and change the output type to number or string - a year is not a date/time value
You do understand you are going to need to run an update script every day?

Philemon Nkafu

@Nic Brough -Adaptavist- Appreciate you getting back to me. Am now stuck at the following:

1. The line to ignore the empty DOB field

2. The line for the recalculation or running everyday.

Below is my updated script. Please can you add the above lines and send back to me. Am really new to scripting and this is challenging to me .

import com.atlassian.jira.component.ComponentAccessor
import java.time.Period
import java.time.LocalDate
import java.time.ZoneId

def customFieldManager = ComponentAccessor.customFieldManager
def dob = customFieldManager.getCustomFieldObjectsByName("DOB")[0]
def dobValue = dob.getValue(issue) as Date

static def convertToLocalDateViaInstant(Date dateToConvert) {
return dateToConvert.toInstant()
.atZone(ZoneId.systemDefault())
.toLocalDate()
}

def today = LocalDate.now()
def birthday = convertToLocalDateViaInstant(dobValue) as LocalDate

def age = Period.between(birthday, today)

return String.format("%d years", age.getYears())

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

scriptrunner

jira

jira-server