AnsweredAssumed Answered

Auto-calculating new dates based on another date field

Question asked by bnuttman on Nov 6, 2012
Latest reply on Nov 6, 2012 by Mike_Mitchell

I want to update a field that changes based on another field.


I have a student entry date field and I want to schedule his quarterly review every 3 months. This is easy to do with a second calculated field.

The problem I am having is to automatically schedule the next quarterly review for the next period.

For example, if the student entry date field is 3/5/2012(This date does not change), then the first quarterly review field should be 6/5/2012. When the date 6/5/2012 comes around the quarterly review field should then be set to 9/5/2012. And ongoing....

Any ideas on how to make this work?