Need help calculating elapsed time in years, months, and days.
I'm a self taught database user who is largely unfamiliar with mathematical functions. I want to create a field that will calculate the length of time a student has been in my piano studio. I have the fields "Joined Studio" and "Length of Study" created but I don't know how to program the calculation. I want the result to show as years, months, and days. Can anyone help me?