Open Dental Forum

Hello all:

Wondering how can I generate a report listing new patients to the office.

Thanks

This query is from the query examples page. You can modify it to get a report with the specific fields you would like and the dates you want:

SELECT * FROM PATIENT
WHERE DateFirstVisit >= '2005-10-01'
AND DateFirstVisit < '2005-11-01'


Jorge Bonilla, DMD

Thanks i'll try it.