AboutJamey Key Expertise NEW and INTERMEDIATE USERS. WHAT CAN FILEMAKER PRO DO FOR ME? I have been using FileMaker products for over 10 years and have basic knowledge in all areas of FileMaker database set up and use. I`m not prepared to answer questions about complex situations or calculations but can help beginners and intermediate users set up and use FileMaker databases.
Experience Have been using FileMaker since 1989 in our business. We have 10 users on the network who use these databases every day. Our largest databases have had over 30,000 records at one time. In 1995 one of my files was chosen as "Most Unique Database" in a contest sponsored by Claris, maker of FileMaker. Recently I have developed a set of files for new computer system installed at our church.
I am trying to calculate an "end date" based on a "start date" that is already recorded in a field in my filemaker database. The end date needs to be exactly 6 months after the start date.
Any idea of how to generate the end date automatically?
My start date field is named: MadeDateOnly
The end date filed will be named: MIPEndDateOnly
Thanks!
Answer Hello Mike;
The easiest way is to try making the MIPEndDateOnly a calculation with the result of a date. The calculation is MadeDateOnly + 183
The only problem is that it may not end on the exact day 6 months later, but will add 183 days.
If you need it to end on June 6th, if the start date is Jan. 6th, then we will have to make a more complicated calculation. Let me know if you need that.
