I have two formula fields that are working beautifully. The first, Child's Age, calculates (based on a child's birthdate) whether the child is under 3, between 3 and 5, and Over 5. The second, a checkbox called Active MCH, is checked if the child is under five but unchecked if the child is over 5. This all works great.
Now, though, they want to uncheck the box 30 days AFTER the child's birthdate, not on it. I thought I could just create another checkbox called Active in Program and create a workflow that unchecked it 30 days after the first checkbox is unchecked.
This does not work. I thought the problem was that I was updating the checkbox based on a formula field, so I tried creating a Text field with the value in the Child's Age field. I couldn't get this field (Child's Age(text)) to populate with the values from the Child's Age field.
How do I do this time-based workflow so the kids get 30 days grace period after their 5th birthday before they are removed from the program?