Important Date Fields

·        All classes contain the MODIFIED field which is a date and time the record as last changed.  For new listings, this date and time is when the listing was added to MLS.

·        Some RETS Security Profiles may include DAYSONMARKET and CDOM (Cumulative Days on Market).  When these fields are updated, the MODIFIED field is not updated. 

·        The MODIFIED field on the MEDIA class is updated when the media is added or modified.  This does not change MODIFIED field on the property classes.

·        The STATUSCHANGEDATE is the date and time a status is changed on a listing.  Listing with ACT, CON, OPT, or KO status do not have a STATUSCHANGEDATE, but all other statuses will have value for this field.  This allows you to download all records that Expired, went Pending, were Withdrawn or Cancelled or were sold by entering one date in this field.

Updated: 2/19/2008