As always, let us know what you think, tell us your ideas for adapting it, and give us suggestions for templates that you think we might be missing.
UPDATE: there was a bug in the Due date calculation that existed in the template up until 07/12/2022. If you installed it prior to this date, please see the following:
I’m giving this template a shot, but I want to create a new Interval for Bi-Annual. Where is the Interval.Period being obtained from in the formula for Due date in the Maintenance requirement Database? It appears that the Single Select items have an extra hidden property called Period, but I see no way to add a new one.
I’ve discovered a bug in the Due date calculation (in the Maintenance Requirement database)
Not only might it not work if the interval period was greater than 12, it would also not work if the interval was 12 months and the date of the last successful event fell in a December(!)
Sorry!
Please replace the Due date formula with the following:
Date(Year([Date of last (successful) event]) + RoundDown(((Month([Date of last (successful) event]) + Interval.Period) - 1) / 12,0),(Month([Date of last (successful) event]) + Interval.Period) - (12 * RoundDown(((Month([Date of last (successful) event]) + Interval.Period) - 1) / 12,0)),Least(Day(Date(Year([Date of last (successful) event]) + RoundDown(((Month([Date of last (successful) event]) + Interval.Period) - 1) / 12,0),((Month([Date of last (successful) event]) + Interval.Period) + 1) - (12 * RoundDown((Month([Date of last (successful) event]) + Interval.Period) / 12,0)),1) - Days(1)),Day([Date of last (successful) event])))
This applies to anyone who has already installed it.
Sorry for the mistake.
Let me know if you encounter any more odd behaviours(!)