/
Validation rule: End_Year_Must_be_Numeric

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

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

Validation rule Details

Name

End_Year_Must_be_Numeric

Label

End_Year_Must_be_Numeric

Object

AQB__AreaOfStudy__c

Active

Yes

Formula

AND(
LEN (AQB__EndYear__c) <> 0,
NOT(REGEX(AQB__EndYear__c, "[0-9-]{4}"))
)

Error message

End Year must be a numeric year.

Error location

End Year

Related content

Validation rule: Start_Year_Must_be_Numeric
Validation rule: Start_Year_Must_be_Numeric
TAP - Advancement Portfolio Product
More like this
Validation rule: Start_Year
Validation rule: Start_Year
TAP - Advancement Portfolio Product
More like this
Validation rule: Entry_Class_Must_be_Numeric
Validation rule: Entry_Class_Must_be_Numeric
TAP - Advancement Portfolio Product
More like this
Validation rule: Stop_Year
Validation rule: Stop_Year
TAP - Advancement Portfolio Product
More like this
Validation rule: GMRGift_Year_Min
Validation rule: GMRGift_Year_Min
TAP - Advancement Portfolio Product
More like this
Validation rule: Preferred_Year
Validation rule: Preferred_Year
TAP - Advancement Portfolio Product
More like this