Days on Market and others?
Our application will download new/updated records once a day (via RETS). I expect that days on market (DOM) reflects the CURRENT number of days for active listings; for sold listings, obviously it will reflect the total number of DOMs. Further, I assume that an active listing will not trigger an update/download tomorrow because the DOM increased by one. Correct?
So in my application (the forms/reports) it will calculate DOM for active listings. When an active listing is sold, an updated record will be downloaded and the change saved. Correct?
A follow on question is if there other calculated fields that I need to watch out for?
Thanks for your guidance.