Assign category by date

[bvcastro]

Hello,

I am building a database for registration of our local soccer leage using FM 11,

1. we have 7 divisions by age/date

U06 = 8/1/2004

U08 = 8/1/2002

U10 = 8/1/2000

Etc....

2. I created an entry field for DOB

I would like for the division to be calculated when DOB dae is entered.

Thank you for your help....

[Matthew F]

Try the following:

1. Define 3 global number variables: ref month, ref day, and ref year.

2. Enter 8, 1, and 2004 into these fields. (You can change them for other seasons.)

3. Use the following calculation:

Case ( 

Birthdate < Date ( Ref month ; Ref day ; Ref year ) ; "Young" ; 

Birthdate < Date ( Ref month ; Ref day ; Ref year + 1) ; "U06" ; 

Birthdate < Date ( Ref month ; Ref day ; Ref year + 2) ; "U07" ; 

Birthdate < Date ( Ref month ; Ref day ; Ref year + 3) ; "U08" ; 

Birthdate < Date ( Ref month ; Ref day ; Ref year + 4) ; "U09" ; 

Birthdate < Date ( Ref month ; Ref day ; Ref year + 5) ; "U10" ; 

Birthdate < Date ( Ref month ; Ref day ; Ref year + 6) ; "U11" ; 

Birthdate < Date ( Ref month ; Ref day ; Ref year + 7) ; "U12" ;

"Old" )