Resource: Property, Field : CancellationDate

Description

CancellationDate must be the same day or after the list contract date.

Error Messages

1) ERROR, the cancellation date cannot be in the future.
2) ERROR, the cancellation date cannot be prior to the contract date.

Fields referenced within this rule

CancellationDate

ListingContractDate

StandardStatus

Syntax with comments and error messages

//[ErrMsg1^ERROR, the cancellation date cannot be in the future.|LogicBlk1^TRUE|LogicBlk2^FALSE]
//[ErrMsg2^ERROR, the cancellation date cannot be prior to the contract date.|LogicBlk1^TRUE|LogicBlk3^FALSE|LogicBlk4^TRUE]
// If entry is not empty and has changed...
IIF((/*[LogicBlk1]*/(.ENTRY. != .EMPTY.).AND.(.ENTRY. != .OLDVALUE.)),
// Then entry must be today or in the past, entry must be same day or after the list contract date, and standard status must be 'closed'.
((/*[LogicBlk2]*/.ENTRY. <= .TODAY.).AND.((/*[LogicBlk3]*/.ENTRY. >= ListingContractDate).AND.(/*[LogicBlk4]*/StandardStatus.IN.('K')))),
// Else accept empty entry.
.TRUE.)
//(.ENTRY. = .EMPTY.) .OR. (.OLDVALUE. = .ENTRY.) .OR. (.ENTRY. <= .TODAY.) .OR.
//((.ENTRY. >= ListingContractDate) .AND. (StandardStatus .IN. ('K'))) .OR.
/ / .NOT.(StandardStatus.IN.('K'))

Syntax only

IIF(((.ENTRY. != .EMPTY.).AND.(.ENTRY. != .OLDVALUE.)),((.ENTRY. <= .TODAY.).AND.((.ENTRY. >= ListingContractDate).AND.(StandardStatus.IN.('K')))),.TRUE.) / / .NOT.(StandardStatus.IN.('K'))

Rule Unique ID

07b89561-1ed4-4c18-81e6-c96a34a6d69a

ACCEPT