I need to create a calculated field based on a date. I am working with a school database and I was able to create a calculated field to figure out their age. But I need to create another calculated field to identify their date at the start of the school year. This is the age calculation
DiffInYears(asa_studentdob, Now()).
What I want to do is replace the Now() with the first day of school. If I add a date it gives me an error. Is there a way to do this?
