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.

Regards,
Greg Wagner-


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

Hi,

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

Thanks.
Beth Oakland
Data Manager