I have a requirement of calculating the age in years and months based on a date of birth field:

[Deepanshi Sood]

Hi all,
@Ankur Bawiskar 
@palanikumar 
I have a requirement of calculating the age in years and months based on a date of birth field:

Age is a single line text variable and is read only. It should populate age based on date of birth in a format like : example : 5 years 4 months.

I am not knowledgable to glide date functions. Can someone help me with a script for this?

Thanks in advance!

[Deepanshi Sood]

Hi Ankur, This script is to be written in script include of client script?

[Ankur Bawiskar]

Hi,

you can use GlideAjax as the script requires date in Nov 25, 2000 format and not yyyy-MM-dd

Use onChange client script with Ajax and pass the date

Regards
Ankur

[Deepanshi Sood]

Hi Ankur, It's giving me javascript error

client script:

script include:

checkAge: function() {
var dob = this.getParameter(sysparam_id);
var dt = new GlideDate();
dt.setValue(dob);

var newFormat = dt.getByFormat("MMM dd, yyyy");
var diff = Date.now() - Date.parse(newFormat);

var seconds = Math.floor(diff/1000);
var minutes = Math.floor(seconds/60);
var hours = Math.floor(minutes/60);
var days = Math.floor(hours/24);
var months = Math.floor(days/30);
var years = Math.floor(days/365);

seconds %= 60;
minutes %= 60;
hours %= 24;
days %= 30;
months %= 12;

gs.info("Years->" + years);
gs.info("Months->" + months);
},

Please help

[Ankur Bawiskar]

Hi,

why to use JSON parse?

Do this

checkAge: function() {
var dob = this.getParameter('sysparam_id'); // it should be in quotes
var dt = new GlideDate();
dt.setValue(dob);

var newFormat = dt.getByFormat("MMM dd, yyyy");
var diff = Date.now() - Date.parse(newFormat);

var seconds = Math.floor(diff/1000);
var minutes = Math.floor(seconds/60);
var hours = Math.floor(minutes/60);
var days = Math.floor(hours/24);
var months = Math.floor(days/30);
var years = Math.floor(days/365);

seconds %= 60;
minutes %= 60;
hours %= 24;
days %= 30;
months %= 12;

return years + ' years ' + months + ' months';
},

Update client script

alert(answer);

// remove the parsing line

Regards
Ankur

[Deepanshi Sood]

Hi, I removed the parsing line:

function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
var ga = new GlideAjax('HRAjaxUtils');
ga.addparam('sysparam_name','checkAge');
ga.addParam('sysparam_id',g_form.getValue('dob'));

ga.getXML(getData);

function getData(response) {

var answer = response.responseXML.documentElement.getAttribute("answer");
alert(answer);
}

}

and updated the SI as well. Doesn't work