Update Records based on Dates in the Record
Looking to change fields in a record when the today is equal to a date field. Eg. Update status for a record to "Active" when today is equal to "subscription start" date field.
Forum Discussion
it would be best to have the status field be calculated. Typically, you might have a field called status Override and then a calculated Status field. The Status override would be a multiple choice field.
The Status field would be a formula like
I([Status Override] <> "", [Status Override], Today() >= [subscription start], "Active")
The Status field would be a formula like
I([Status Override] <> "", [Status Override], Today() >= [subscription start], "Active")