Good afternoon,
For simplicity purposes let's say that I have 3 date fields (date1, date2, date3). These fields can be updated and they are all a week apart so if date1 is "4/26/2017", then date2 would be "5/3/2017" and date3 would be "5/10/2017"
When I change date1, using the datepicker the other two dates change automatically because of the way I have them setup in the "Calculation-->Advanced" screen.
So in the "Calculation-->Advanced" screen for date2 I have "=date1+7" and in the "Calculation-->Advanced" screen. for date 3 I have "=date2+7".
This works great if I only wanted to update from the first box. What I'm looking for now is to be able to change any given date box and have the other two adjust.
For example, if I change date2, date3 should add 7 to the value of date2 and date1 should subtract 7 from the value of date2.
I know I can work up a javascript and push the calculations, but in my real scenario I have about 6 date boxes to which I would have to script a case for each, and I was wondering if there is a built in function or if anyone has worked up something similar, that could save me some research time.
Thanks,
Raul Gonzalez