Resource: Property, Field : OnMarketDate

Description

OnMarket date must be after the listing contract date unless the seller has seller instructed to exclude set to yes.

Error Messages

1) ERROR, 'on market date' field cannot be altered unless the 'seller instructed to exclude Y/N' field is set to 'Yes'.
2) ERROR, 'on market date' field cannot be in the future.
3) ERROR, 'on market date' field cannot be prior to the listing contract date.
4) ERROR, 'on market date' field validity cannot be evaluated if the 'listing contract date' field is empty.

Fields referenced within this rule

ListingContractDate

OnMarketDate

SellerInstructedToExcludeYN

StandardStatus

Syntax with comments and error messages

//[ErrMsg1^ERROR, 'on market date' field cannot be altered unless the 'seller instructed to exclude Y/N' field is set to 'Yes'.|LogicBlk1^FALSE|LogicBlk2^TRUE|LogicBlk6^FALSE]
//[ErrMsg2^ERROR, 'on market date' field cannot be in the future.|LogicBlk1^FALSE|LogicBlk2^TRUE|LogicBlk5^FALSE]
//[ErrMsg3^ERROR, 'on market date' field cannot be prior to the listing contract date.|LogicBlk1^FALSE|LogicBlk2^TRUE|LogicBlk4^FALSE]
//[ErrMsg4^ERROR, 'on market date' field validity cannot be evaluated if the 'listing contract date' field is empty.|LogicBlk1^FALSE|LogicBlk2^TRUE|LogicBlk3^FALSE]
// If 'standard status' is set to Incomplete, bypass rule, let user enter information without checks...
(/*[LogicBlk1]*/StandardStatus.IN.('I')).OR.
// If the entry is not empty...
IIF((/*[LogicBlk2]*/.ENTRY. != .EMPTY.),
// Then check whether the listing contract date is not empty and...
(/*[LogicBlk3]*/ListingContractDate != .EMPTY.).AND.
// the entry is the same day of after the listing contract date and the entry is today or in the past and...
(((/*[LogicBlk4]*/.ENTRY. >= ListingContractDate).AND.(/*[LogicBlk5]*/.ENTRY. <= .TODAY.)).AND.
// the seller has instructed to exclude.
(/*[LogicBlk6]*/SellerInstructedToExcludeYN = .TRUE.)),
// Else accept the empty entry.
.TRUE.)
// (.ENTRY. = .EMPTY.) .OR. ((.ENTRY. >= ListingContractDate) .AND. (.ENTRY. <= .TODAY.)) .OR.
/ / (StandardStatus = 'I').OR.(SellerInstructedToExcludeYN = .FALSE.)

Syntax only

(StandardStatus.IN.('I')).OR.IIF((.ENTRY. != .EMPTY.),(ListingContractDate != .EMPTY.).AND.(((.ENTRY. >= ListingContractDate).AND.(.ENTRY. <= .TODAY.)).AND.(SellerInstructedToExcludeYN = .TRUE.)),.TRUE.) / / (StandardStatus = 'I').OR.(SellerInstructedToExcludeYN = .FALSE.)

Rule Unique ID

448ef272-cf12-4a7a-a7d1-41f1b12a796f

ACCEPT