Would like to help you out, but your request is beyond my knowledge. However, I was wondering if you'd be willing to share your coding to compute age calculations? I was only able to base my calculation on the year of birth, meaning that the resulting ages are inaccurate when the current date precedes the date of the birth.
most age calculations use an expression similar to this:
Let ( [
Today = Get (CurrentDate) ;
bDay = Date ( Month ( BirthdateField ) ; Day ( BirthdateField ) ; Year ( Today ) );
Age = Year ( Today ) - Year ( BirthdateField ) - ( Today < bDay )
If ( Age > 0 ; Age ; "" )
Because Get ( CurrentDate ) is used, this calculation must be unstored.
To use a different date other than Today, simply modify the first part of this expression, Today = .... to refer to a date field where you specify this different date: Today = DateField
This is what I used for age that works well for us.
Let ( [now = Get ( CurrentDate ) ;thisBD = Date ( Month ( DOB ) ; Day ( DOB ) ; Year ( now ) ) ;passed = now < thisBD ] ;Year ( now ) - Year ( DOB ) - passed)
Thanks Phil. That works awesome. Just what I needed!