Validation rule: SpendPlan_Last_Authorisation_Date

Name

SpendPlan_Last_Authorisation_Date

Label

SpendPlan_Last_Authorisation_Date

Object

Spending_Plan__c

Active

Yes

Formula

AND(
ISCHANGED(Latest_Activation_Date__c),
NOT(AND(
Latest_Activation_Date__c <= TODAY(),
Latest_Activation_Date__c > Latest_Submission_Date__c
)
)
)

Error message

Last Authorisation Date must be between Last Submission Date & today

Error location

Last Authorisation Date