date range question

[BonnieH]

I need to determine the projected kindergarten school enrollment date based upon a student's date of birth. For example: If the student's date of birth falls between the dates 9-1-1997 and 8-31-1998 they will enroll in kindergarten in the school year 03/04. I have tried a calculation field with an "if "calculation but I cannot seem to get this to work. I have searched other posted sites for days and cannot find a simple solution. Please help!

[BobWeaver]

This will give you the enrollment year (ie., 2003):

Year(Birthdate)+(Month(Birthdate)>8)+5

If you want to display it as 03/04 etc., then you can do the following:

Right(Year(Birthdate)+(Month(Birthdate)>8)+5,2)&"/"&Right(Year(Birthdate)+(Month(Birthdate)>8)+6,2)

Set the result of this calculation to type "text"

[BonnieH]

Thanks! It works like a charm! Saved me tons of time.