/
Validation rule: SpendPlan_ExpiryDate_Max

Attention: Confluence is not suitable for the storage of highly confidential data. Please ensure that any data classified as Highly Protected is stored using a more secure platform.
If you have any questions, please refer to the University's data classification guide or contact ict.askcyber@sydney.edu.au

Validation rule: SpendPlan_ExpiryDate_Max

Owned by praveen.sampath
Aug 16, 2024
1 min read

Validation rule Details

Name

SpendPlan_ExpiryDate_Max

Label

SpendPlan_ExpiryDate_Max

Object

Spending_Plan__c

Active

Yes

Formula

Expiry_Date__c >

DATE (
YEAR( Start_Date__c ) + 10,
MONTH( Start_Date__c ),
DAY( Start_Date__c )
) - 1

Error message

Expiry Date must not be greater than ten years after the Start Date

Error location

Expiry Date

Description

Expiry Date must be equal to or less than 10 years after the start date

Related content

Validation rule: SpendPlan_ExpiryDate_Min
Validation rule: SpendPlan_ExpiryDate_Min
TAP - Advancement Portfolio Product
More like this
Validation rule: AllottedFunds_FY_Within_SP_Period
Validation rule: AllottedFunds_FY_Within_SP_Period
TAP - Advancement Portfolio Product
More like this
Validation rule: PlannedFundg_FY_Within_SP_Period
Validation rule: PlannedFundg_FY_Within_SP_Period
TAP - Advancement Portfolio Product
More like this
Validation rule: SpendPlan_Last_Authorisation_Date
Validation rule: SpendPlan_Last_Authorisation_Date
TAP - Advancement Portfolio Product
More like this
Validation rule: Date_Check
Validation rule: Date_Check
TAP - Advancement Portfolio Product
More like this
Validation rule: END_DATE_PROGRAM_DATES
Validation rule: END_DATE_PROGRAM_DATES
TAP - Advancement Portfolio Product
More like this