/
Validation rule: PlannedFundg_FY_Within_SP_Period

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: PlannedFundg_FY_Within_SP_Period

Validation rule Details

Name

PlannedFundg_FY_Within_SP_Period

Label

PlannedFundg_FY_Within_SP_Period

Object

Planned_Funding__c

Active

No

Formula

OR(
VALUE(Financial_Year__c) < YEAR( Spending_Plan_ID__r.Start_Date__c ),
VALUE(Financial_Year__c) > YEAR( Spending_Plan_ID__r.Expiry_Date__c ),
REGEX( Financial_Year__c,"^[a-z A-Z]*$")
)

Error message

Financial Year must be within the Spending Plan's period.

Error location

Year

Description

Financial Year must be a year within the period of the spending plan

Related content

Validation rule: AllottedFunds_FY_Within_SP_Period
Validation rule: AllottedFunds_FY_Within_SP_Period
More like this
Validation rule: PlannedFund_RdmpnCaptlNotGreaterThan0
Validation rule: PlannedFund_RdmpnCaptlNotGreaterThan0
More like this
Validation rule: SpendPlan_ExpiryDate_Max
Validation rule: SpendPlan_ExpiryDate_Max
More like this
Validation rule: SpendPlan_ExpiryDate_Min
Validation rule: SpendPlan_ExpiryDate_Min
More like this
Validation rule: PlannedExp_Less_Than_1B
Validation rule: PlannedExp_Less_Than_1B
More like this
Validation rule: PlannedFundg_Cannot_Be_Negative_ASA
Validation rule: PlannedFundg_Cannot_Be_Negative_ASA
More like this