We have a Month to Date report which picks up deals which detect when a record was placed into a certain status. In this case the KEY2 Field which is found in the CONTACT1 table is set to SLC.
At the beginning of this month, the report in question picked up the record and pulled it into the report but when the report ran last Friday, we noticed the goldmine record in question had dropped off the list. Upon changing the KEY2 Field data to SLC, the record again started to appear on the report despite the KEY2 field already being populated with the value SLC.
I suspect there is something wrong with the logic of the report so Ive included it here on this question.