AnsweredAssumed Answered

Calculating school year based on date of birth

Question asked by james239 on Aug 18, 2009
Latest reply on Feb 10, 2017 by beverly

Title

Calculating school year based on date of birth

Post

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......

Outcomes