Forum Discussion
JohnFreire
7 years agoQrew Member
Oops, one more change...
I had to modify one of the formulas, it was giving negative numbers. Here is my revised formula
3) [Age - Months] - Formula Numeric field - with formula:
var Date OneMonthOldBirthday = AdjustMonth( [Date of Birth], 1);
var Number TodayMonth = Month( Today() );
var Number TodayDay = Day( Today() );
var Number BirthdayMonth = Month( [Date of Birth] );
var Number BirthdayDay = Day( [Date of Birth] );
If (
Today() < $OneMonthOldBirthday, 0,
$TodayMonth = $BirthdayMonth and $TodayDay >= $BirthdayDay, 0,
$TodayMonth = $BirthdayMonth and $TodayDay < $BirthdayDay, 11,
$TodayDay = $BirthdayDay and $TodayMonth > $BirthdayMonth, $TodayMonth - $BirthdayMonth,
$TodayDay = $BirthdayDay and $TodayMonth < $BirthdayMonth, $TodayMonth + 12 - $BirthdayMonth,
$TodayMonth > $BirthdayMonth and $TodayDay > $BirthdayDay, $TodayMonth - $BirthdayMonth,
$TodayMonth > $BirthdayMonth and $TodayDay < $BirthdayDay, $TodayMonth - $BirthdayMonth -1,
$TodayMonth < $BirthdayMonth and $TodayDay > $BirthdayDay, $TodayMonth + 12 - $BirthdayMonth,
$TodayMonth < $BirthdayMonth and $TodayDay < $BirthdayDay, $TodayMonth + 11 - $BirthdayMonth
)
I had to modify one of the formulas, it was giving negative numbers. Here is my revised formula
3) [Age - Months] - Formula Numeric field - with formula:
var Date OneMonthOldBirthday = AdjustMonth( [Date of Birth], 1);
var Number TodayMonth = Month( Today() );
var Number TodayDay = Day( Today() );
var Number BirthdayMonth = Month( [Date of Birth] );
var Number BirthdayDay = Day( [Date of Birth] );
If (
Today() < $OneMonthOldBirthday, 0,
$TodayMonth = $BirthdayMonth and $TodayDay >= $BirthdayDay, 0,
$TodayMonth = $BirthdayMonth and $TodayDay < $BirthdayDay, 11,
$TodayDay = $BirthdayDay and $TodayMonth > $BirthdayMonth, $TodayMonth - $BirthdayMonth,
$TodayDay = $BirthdayDay and $TodayMonth < $BirthdayMonth, $TodayMonth + 12 - $BirthdayMonth,
$TodayMonth > $BirthdayMonth and $TodayDay > $BirthdayDay, $TodayMonth - $BirthdayMonth,
$TodayMonth > $BirthdayMonth and $TodayDay < $BirthdayDay, $TodayMonth - $BirthdayMonth -1,
$TodayMonth < $BirthdayMonth and $TodayDay > $BirthdayDay, $TodayMonth + 12 - $BirthdayMonth,
$TodayMonth < $BirthdayMonth and $TodayDay < $BirthdayDay, $TodayMonth + 11 - $BirthdayMonth
)