AnsweredAssumed Answered

Age Calculation help needed.....

Question asked by taffy on Oct 24, 2010
Latest reply on Oct 25, 2010 by taffy

Title

Age Calculation help needed.....

Post

I have a FM database of youth soccer players - including their birth dates.

Based on birth dates I need FM to calculate what age group the player is eligible to play in.

 

For instance - if the player is born on or between 8/1/92 and 7/31/93 - then they can play on a U18 team.

 

Can somebody help me with the Filemaker formula / process that will return the age group eligibility based on birth date.

Thanks in Advance....

 

 

U18 8/1/92 – 7/31/93 

U17 8/1/93 – 7/31/94 

U16 8/1/94 – 7/31/95 

U15 8/1/95 – 7/31/96 

U14 8/1/96 – 7/31/97 

U13 8/1/97 – 7/31/98 

U12 8/1/98 – 7/31/99 

U11 8/1/99 – 7/31/00 

U10 8/1/00 – 7/31/01 

U9 8/1/01 – 7/31/02 

U8 8/1/02 – 7/31/03 

U7 8/1/03 – 7/31/04 

U6 8/1/04 – 7/31/05 

U5 8/1/05 – 7/31/06 

U4 8/1/06 – 7/31/07

Outcomes