Calculating school year based on date of birth
I am trying to create a calculated field for a person's school year (UK) based on their date of birth falling between two dates of birth, ie. 1st September 2003 and 31st August 2004
I have tried the following:
If ( dob > 1/9/2003 and dob < 31/8/2004 ; 1 ; Other )
Hoping that 4/2/2004 would return a 1, but it returns Other
Any help please......