AnsweredAssumed Answered

Need help calculating elapsed time in years, months, and days.

Question asked by Heather on May 29, 2011
Latest reply on Nov 7, 2011 by DavidSmith1348

Title

Need help calculating elapsed time in years, months, and days.

Post

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?

Outcomes