Question:We are having an awards type banquet and I need an ad hoc report that will show the longest sale in escrow?
Answer: Here's how this will have to work since WinMORE cannot track specifically contract to close timeline. Make sure to change the date range to the period you want the report pulled for.
Here's the Ad Hoc to pull from WinMORE. When you pull this, click "Save to File" & it will save as a text file in \WINMORE3\MDAT\REPORTS folder:
LIST AGT_TRANS BY AGENT BY CLOSE_PERIOD WITH STATUS = 'P' AND WITH CLOSE_PERIOD BETWEEN 201001 AND 201012 BREAK-ON AGENT NAME_L STATUS PROPERTY STREET_NO DATE_CONTR DATE_CLOSED TOTAL CLOSED TOTAL PRICE_VOLUME TOTAL GCI
After running the report, import it into Excel & run a formula to calculate the # of days & sort accordingly.