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!

[Jaspal Singh]

Hi Anshi,

There already exists a solution for this in one of other thread. Refer link for a check & update it with the variables you using accordingly.

[Deepanshi Sood]

Hi @Jaspal Singh This doesn't give me the age in the format that I need.
I need it in '7 years 5 months' (example)

[Ankur Bawiskar]

Hi,

can you check this link;

this might help you to do in your format

1) get the difference and then use this

https://stackoverflow.com/questions/38355157/is-there-a-method-to-convert-miliseconds-to-years-month...

Regards
Ankur

[Ankur Bawiskar]

@Anshi 

Please check the below sample script which worked for me

1) Pass the date from client to server in ajax and then do that

Script: Date of Birth 25th Nov 2000

var date = '2000-11-25';

var dt = new GlideDate();
dt.setValue(date);

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

Output:

Actual: Compare with online tool

Regards
Ankur