I need to work out what class a pupil is in. In this system they start in year 1 if they are four years old before 1 July. e.g. born 29 June 2016 will join year 1 in Sept 2020 were as born 4 July 2016 will wait until Sept 2021. I'm happy with the maths for my true & false.
The following works SO LONG AS THEY WEREN'T born in a leap year.
YearGroup: IIf(DatePart('y',[DOB])<DatePart('y',#01/06/2020#),"true","false")
I can't work out how to check against 1 June YEAR OF BIRTH. Bee trying stupid stuff like
YearGroup: IIf(DatePart('y',[DOB])<DatePart('y',#01/06/#DatePart('yyyy',[DOB]),"true","false")
Any ideas would be very welcome. I'm new here.
The following works SO LONG AS THEY WEREN'T born in a leap year.
YearGroup: IIf(DatePart('y',[DOB])<DatePart('y',#01/06/2020#),"true","false")
I can't work out how to check against 1 June YEAR OF BIRTH. Bee trying stupid stuff like
YearGroup: IIf(DatePart('y',[DOB])<DatePart('y',#01/06/#DatePart('yyyy',[DOB]),"true","false")
Any ideas would be very welcome. I'm new here.