I'm working on updating a Date Formula, which tracks the date a report is due based off of an Application Due Date field. Currently, if an application is awarded and I input 1-1-2015 into the Application Due Date field, the Date Formula field (i.e. when a report is due) will return 7-1-2015, which is 6 months later. The below is what's currently used:
If ([Selected/Awarded] = true,
If ([Application Due Date]=Date(2013, 8, 31), Date(2014, 5, 19),
If ([Application Due Date]=Date(2013, 10, 15), Date(2014, 5, 19),
If ([Application Due Date]=Date(2014, 1, 1), Date(2014, 5, 19),
If ([Application Due Date]=Date(2014, 5, 1), Date(2014, 11, 15), AdjustMonth([Application Due Date], 6))))),
I now need the ability to be more flexible with the report dates, i.e., it's not necessarily 6 month increments anymore. So that I don't have to erase the formula and go back and manually input all the old report dates and new dates going forward, I would like to try to add to/modify this formula.
Ultimately what I'm hoping for is that any files in the database that have Application Due Dates prior to 5-1-2015 would still use the above formula to determine when a report is due, while any applications that have Application Due Dates on/after 5-1-2015 would be manual text inputs into a Date field by me since the 6 month formula isn't valid anymore.
Make sense? Is it even possible?