Year ( get ( currentDate) - Year ( dateOfBirthField ) + 1
This doesn't work as it adds 1 year to all the ages now, and I don't the increase to happen until Jan 1st
Example: D.O.B. March 23 2012 , current age 4, but i want it to be 5 as from Jan 1 2017 and change again until Jan 1 2018.
Then remove the + 1
Sent from my iPhone
Thanks, like I said I'm new at this.
Would there be a way to do this on Aug 1 of each year as well , for horses born in the Souther Hemisphere?
That's a bit trickier as you can't just subtract the year values.
Let ( T = Get ( CurrentDate ) ; Year ( T ) - Year ( DateOfBirthFIeld ) - ( Month ( T ) < 8 )
Last term in parenthesis evaluates as 1 (True) if the current month is Jan - July and evaluates as 0 otherwise so this conditionally reduces the calculated age by 1 if the current month is in that range.
BTW, this isn't a script, but a calculation. (a picky point, but when "tech speaking" picky points are needed to ensure no misunderstandings.)