Hello! I just purchased TapForms as a student records database for my martial arts school and it is working great! Is there a formula available for a date calculation to show total time from a start date to the current date? So if a student starts on July 5th 2010, it will show how many years, months and days from then to whatever the current date is. Thank you for a terrific product! Ron
Hi Ron,
Thanks for purchasing Tap Forms!
You can get the number of years and days quite easily, but it will be represented as a decimal amount. For example, 4.5 years.
Here’s a formula for that:
(End Date – Start Date) / 60 / 60 / 24 / 365.25
That’ll give you the number of years between the start and end dates.
It works this way because the result of subtracting two dates from each other is the number of seconds between those two dates. So you have to do a bit of math to convert that to days or years. If you just want the number of days, you can leave off the divide by 365.25.
Hope that helps!
Brendan
Thank you – that works perfectly! :)