BonnieH

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

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!