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

MISC Custom Fields: Calculate person's age

Hi! i'm using JIRA 6.3.9

I have date of birth, and i need JIRA to count his age.

I tryed this formula:

@Formula: issue.get("created")==null ? null : ((new Date().getTime()) - issue.get("customfield_xxxxx").getTime()) / 1000 / 31536000 -->

It works close, but not perfect. If i put date of birth 20 december 1974 - it will count 40 years (instead of 39)

Accepted answers

David _old account_

That's because the value is rounded up to the nearest integer. If you want to truncate the value instead, use Math.floor( ):

@Formula: issue.get("created")==null ? null : Math.floor(((new Date().getTime()) - issue.get("customfield_xxxxx").getTime()) / 1000.0 / 31536000) --&gt;

All comments

David _old account_

That's because the value is rounded up to the nearest integer. If you want to truncate the value instead, use Math.floor( ):

@Formula: issue.get("created")==null ? null : Math.floor(((new Date().getTime()) - issue.get("customfield_xxxxx").getTime()) / 1000.0 / 31536000) --&gt;

still 40 years. I think thats because it don't count 29 february every 4 years

David _old account_

Yes, you should divide by 31557600 (365,25 days per year).

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-administration

addon-com.innovalog.jmcf.jira-misc-custom-fields