/
Validation rule: END_DATE_WITHIN_PROGRAM_DATES

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_DATE_WITHIN_PROGRAM_DATES

Validation rule Details

Name

END_DATE_WITHIN_PROGRAM_DATES

Label

END_DATE_WITHIN_PROGRAM_DATES

Object

pmdm__ProgramEngagement__c

Active

Yes

Formula

OR(
AND(
NOT(ISBLANK(pmdm__EndDate__c)),
NOT(ISBLANK(pmdm__Program__r.pmdm__StartDate__c)),
pmdm__EndDate__c < pmdm__Program__r.pmdm__StartDate__c
),
AND(
NOT(ISBLANK(pmdm__EndDate__c)),
NOT(ISBLANK(pmdm__Program__r.pmdm__EndDate__c)),
pmdm__EndDate__c > pmdm__Program__r.pmdm__EndDate__c
)
)

Error message

Select an end date that's on or after the program start date and on or before the program end date.

Error location

Top of Page

Description

The Program Engagement End Date must fall within the Program Start and End Dates when specified.

Related content

Validation rule: START_DATE_WITHIN_PROGRAM_DATES
Validation rule: START_DATE_WITHIN_PROGRAM_DATES
More like this
Validation rule: END_DATE_PROGRAM_DATES
Validation rule: END_DATE_PROGRAM_DATES
More like this
Validation rule: START_DATE_PROGRAM_DATES
Validation rule: START_DATE_PROGRAM_DATES
More like this
Validation rule: START_DATE_BEFORE_END_DATE
Validation rule: START_DATE_BEFORE_END_DATE
More like this
Validation rule: APPLICATION_DATE_BEFORE_END_DATE
Validation rule: APPLICATION_DATE_BEFORE_END_DATE
More like this
Validation rule: APPLICATION_DATE_BEFORE_START_DATE
Validation rule: APPLICATION_DATE_BEFORE_START_DATE
More like this