Age Calculation with a twist

[TennMan]

I need to calculate a player's age for a soccer league. The calculation needs to find the player's age (League_Age) on Aug-01-xxxx. For example, this season's age is based on the player's age on Aug-01-2001. This age will not be recalculated until Aug-01-2002.

For example, a player with a DOB of Aug-02-1990 will have a League_Age of 10 until Aug-01-2002, even though they have already celebrated their 11th birthday.

I've tried taking the age to number of days old then dividing by 365, but DOBs close to Aug-01 are occasionally wrong (due to leap years I presume). I need a method that is correct 100% of the time year after year, even when the DOBs are 31-July and 01-Aug.

Thanks

[bobsmith]

Case(Month(DOB) = 8 and Day(DOB) = 1,Year(Status( CurrentDate))- Year(DOB),

Month(DOB) > 7,Year(Status( CurrentDate)) - Year(DOB)-1,

Year(Status( CurrentDate) )- Year(DOB))