Date calculation help.
I am very new to FMP and am learning as I construct this database so any help is appreciated.
I have a course table that has Start and End date fields. I have a Calculation field in that table that totals the days trained. I have a Team table that has two calculations for Total training days that just Sums up the Daystrained, and another calculation that subtracts the total days trained from the days alloted 26.
Here is the thing I want to be able to do with these calculations but am not sure of how to do it. I want to have it calculate for the specific year. So each year it will start over calculating up the total days trained, and the total remaining days from 26 alloted days.