function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Andrew DuffyAndrew Duffy 

Auto Update Field

I think I am too close to this problem to think clearly.  It has been a back and forth with this department and it's got my wires crossed.  I am the lone admin and can't seem to think through this one.
We have 32 agencies that each have approval process for the custom object “applications.”  Based off the “Hire Date” (user submitted) they need another field auto populated to avoid bad data.

Agency 1 will need that date on the first of the month 60 days after their hire date.  For example, hired 8/24/22 would be 10/1/22
Agency 2 will need the first of the month 30 days after their hire date. For example, hired 8/24/22 would be 10/1/22

The other agencies all start on the 1st day of the following month that they are hired.  Unless their hire date is the 1st working day of the month (so could be between the 1-3) they can start on that date or wait until the 1st of the next month.  For example, if hired today 8/24/22 insurance would start on 9/1/22.  Or if they were hired on 8/1-8/3(if it was the first working day of month) They would have option to be 8/1-8/3 or 9/1

I know this is not a hard solution, but I am beyond frustrated with the number of revisions this department has had within this project.  I know this is clouding my judgement and I don’t want to do wrong by them.  Any thoughts or advice?