Hi Beth,

Use the Queries Patient View in the Listing module and construct a where clause similar to the following:

date() - datepart(issueddate) > 30 and status='O'

We also will look into a report, which will make obtaining this easier.

Greg Wagner-

-----Original Message-----
From: Beth Oakland
Sent: Friday, April 13, 2007 3:23 PM
To: Support
Subject: ClinPlus Question


If we want to know which queries have been out for more than 30 days, what would we put in the SAS Where Field?

Beth Oakland
Data Manager