Hi there,
I made a calculation for a field called age but it does not work properly can you help me out?
if the birthdate has not passed substract a year it should take one year of but this is not the case please advise.
Thank you
return; if(getDay(birtdate)< getDay(globals.action_date) &&
getMonth(birtdate)<= getMonth(globals.action_date))
{utils.dateFormat(globals.action_date, 'yyyy') -
utils.dateFormat(birtdate, 'yyyy')-1}
else
{utils.dateFormat(globals.action_date, 'yyyy') -
utils.dateFormat(birtdate, 'yyyy')
}