I am creating a Project Management database, and my goal is to track projects that reoccur every year. Rather than creating due dates for project tasks every single year, I want to have FMP calculate the due dates for each task based on the project due date. My thoughts are to create task start and due dates based on the number of weeks out from the project due date.
Task: Recruit Cast
Start Date: 16 weeks before the project due date (Once the week is chosen, then the date would be calculated in another field)
Due Date: 15 weeks before the project due date (Once the week is chosen, then the date would be calculated in another field)
I would also like the start date to always be on a Monday, since most tasks will be started at the beginning of the week.
What functions would I use to create this solution? I am developing this in Filemaker Pro 12.
Thanks for your help!