The requirement = if a case has been closed 30 days or more, and the Status = Closed, it can't be moved to any status other than Closed. There is also a Date field called "Date Closed - Most Recent" that updates when the Case is moved to closed.
Also - under normal circumstances, a case can be re-opened as long as the case has been closed less than 30 days. Here is my validation rule:
IF(
AND(
PRIORVALUE(Status) = "Closed",
ISCHANGED(Status) = TRUE,
TODAY() - Date_Closed_Most_Recent__c >= 30
),
TRUE,
FALSE
)
Any help is greatly appreciated as this is not preventing updates.
Hi Matt, try:
IF(
AND(
TEXT(PRIORVALUE(Status)) = "Closed",
ISCHANGED(Status) = TRUE,
TODAY() - Date_Closed_Most_Recent__c >= 30
),
TRUE,
FALSE
)
