Resource: Property, Field : ListingContractDate
Description
ListingContractDate cannot be prior to todays date and must be a valid date.
Error Messages
1) ERROR, the 'Listing Contract Date' field cannot be in the future.
2) ERROR, the number of days since the 'Listing Contract Date' cannot exceed 913 days.
Fields referenced within this rule
ListingContractDate
StandardStatus
Syntax with comments and error messages
//[ErrMsg1^ERROR, the 'Listing Contract Date' field cannot be in the future.|LogicBlk1^FALSE|LogicBlk2^FALSE|LogicBlk3^TRUE|LogicBlk4^FALSE]
//[ErrMsg2^ERROR, the number of days since the 'Listing Contract Date' cannot exceed 913 days.|LogicBlk1^FALSE|LogicBlk2^FALSE|LogicBlk3^TRUE|LogicBlk5^FALSE]
// Administrator bypass coupled with grandfather clause ...
(/*[LogicBlk1]*/.USERCLASS..IN.('BANGG','BANGP','BANGM','BANGN','BANGQ')).OR.
// Grandfather clause with administrator clause embedded...
(/*[LogicBlk2]*/((.OLDVALUE. = .ENTRY.).OR.(.USERCLASS..IN.('BANGG','BANGM','BANGN','BANGQ'))).AND..NOT.(((LASTStandardStatus = .EMPTY.).OR.(LASTStandardStatus.IN.('I'))).AND.(StandardStatus.IN.('A')))).OR.
// If entry is not empty...
IIF((/*[LogicBlk3]*/.ENTRY. != .EMPTY.),
// Then check whether entry is today or in the past and entry is less than 913 days in the past and entry has transitioned from a status of 'incomplete' to 'active'.
(/*[LogicBlk4]*/.ENTRY. <= .TODAY.).AND.(/*[LogicBlk5]*/FLOAT(DAYS(.TODAY.,.ENTRY.)) < FLOAT(913)).AND.(((LASTStandardStatus = .EMPTY.).OR.(LASTStandardStatus.IN.('I'))).AND.(StandardStatus.IN.('A'))),
// Else ACCEPT the empty entry.
.TRUE.)
Syntax only
(.USERCLASS..IN.('BANGG','BANGP','BANGM','BANGN','BANGQ')).OR.(((.OLDVALUE. = .ENTRY.).OR.(.USERCLASS..IN.('BANGG','BANGM','BANGN','BANGQ'))).AND..NOT.(((LASTStandardStatus = .EMPTY.).OR.(LASTStandardStatus.IN.('I'))).AND.(StandardStatus.IN.('A')))).OR.IIF((.ENTRY. != .EMPTY.),(.ENTRY. <= .TODAY.).AND.(FLOAT(DAYS(.TODAY.,.ENTRY.)) < FLOAT(913)).AND.(((LASTStandardStatus = .EMPTY.).OR.(LASTStandardStatus.IN.('I'))).AND.(StandardStatus.IN.('A'))),.TRUE.)
Rule Unique ID
870a0dd9-92bb-4720-a1ca-6d6107b3c43d
Rule Number
116