Validation rule: Date_of_Death_for_Case_Status

Name

Date_of_Death_for_Case_Status

Label

Date_of_Death_for_Case_Status

Object

Case

Active

Yes

Formula

AND(
RecordType.DeveloperName == 'Join_Separate_Decease_Request',
ISPICKVAL(Type, 'Decease Contact'),
OR(
AND(
ISBLANK(USYD_DateofDeath__c),
TEXT(Status) == 'Ready for Validation'
),
AND(
USYD_DateofDeath__c > TODAY(),
TEXT(Status) == 'Ready for Validation'
),
AND(
ISBLANK(ContactId),
TEXT(Status) == 'Ready for Validation'
)
)
)

Error message

Case Status cannot be set to "Ready for Validation" without a Contact, a Date of Death and Date of Death cannot be a future date

Error location

Top of Page

Description

TAPSS-914: Checks if Date of Death is populated when updating Status to Ready for Validation;
TAPSS-1708: Contact must be populated before the Status can be set to Ready for Validation