Resource: Property, Field : PurchaseContractDate

Description

PurchaseContractDate must be prior to today.

Error Messages

1) ERROR, the 'purchase contract date' cannot be in the future.
2) ERROR, the 'purchase contract date' cannot be a date earlier than the 'listing contract date'.
3) ERROR, the 'purchase contract date' cannot be altered to an earlier date.
4) ERROR, the 'purchase contract date' cannot be evaluated if 'listing contract date' is not set.

Fields referenced within this rule

ListingContractDate

PurchaseContractDate

Syntax with comments and error messages

//[ErrMsg1^ERROR, the 'purchase contract date' cannot be in the future.|LogicBlk1^FALSE|LogicBlk2^TRUE|LogicBlk4^FALSE]
//[ErrMsg2^ERROR, the 'purchase contract date' cannot be a date earlier than the 'listing contract date'.|LogicBlk1^FALSE|LogicBlk2^TRUE|LogicBlk3^TRUE|LogicBlk5^FALSE]
//[ErrMsg3^ERROR, the 'purchase contract date' cannot be altered to an earlier date.|LogicBlk1^FALSE|LogicBlk2^TRUE|LogicBlk6^FALSE|LogicBlk7^FALSE]
//[ErrMsg4^ERROR, the 'purchase contract date' cannot be evaluated if 'listing contract date' is not set.|LogicBlk1^FALSE|LogicBlk2^TRUE|LogicBlk3^FALSE]
// Administrator bypass...
(/*[LogicBlk1]*/.USERCLASS..IN.('BANGG','BANGP','BANGQ')).OR.
// If entry is not empty...
IIF((/*[LogicBlk2]*/.ENTRY. != .EMPTY.),
// Then check that the listing contract date is not empty and that the entry is on or after the listing contract date and...
(/*[LogicBlk3]*/ListingContractDate != .EMPTY.).AND.(/*[LogicBlk5]*/.ENTRY. >= ListingContractDate).AND.
// the entry is today or prior to today and the old entry value is empty or the entry is the same date of a later date than the old value.
((/*[LogicBlk4]*/.ENTRY. <= .TODAY.).AND.((/*[LogicBlk6]*/.OLDVALUE. = .EMPTY.).OR.(/*[LogicBlk7]*/.ENTRY. >= .OLDVALUE.))),
// Else accept the empty entry.
.TRUE.)

Syntax only

(.USERCLASS..IN.('BANGG','BANGP','BANGQ')).OR.IIF((.ENTRY. != .EMPTY.),(ListingContractDate != .EMPTY.).AND.(.ENTRY. >= ListingContractDate).AND.((.ENTRY. <= .TODAY.).AND.((.OLDVALUE. = .EMPTY.).OR.(.ENTRY. >= .OLDVALUE.))),.TRUE.)

Rule Unique ID

f98cbad8-1ad9-47e4-ab29-b7103d1399fd

ACCEPT