Hi Soren
Basically, I took an Excel formula which I was able to convert to Knack’s formulas.
Without this solution I don’t think I’d ever have solved this Adding months to a date. I did end up with a bug/rounding error that was solved by maxing the decimals for this to 15 places.
It’s a little fiddly marrying the logic up for weekly and monthly/yearly cycles.
When the Job is completed you complete a form
which uses a Record Rule to copy the details and the Next Scheduled date to the Scheduled Date field
To do this you need to have a self referencing connection to the same database/object.
Copy a Record Using Record Rules
Hope this helps, and isn’t too much info.
Feel free to ask any more questions as I’m sure there are other like us who must require a method for calculating recurring dates.