I need to calculate the age in years between two date fields. The date of birth and the beginning of the semester date. Both dates are in the YYMD format. I tried the YMD(birthdate,semesterdate) but that didn't work.This message has been edited. Last edited by: Trudy,