Open Dental Forum

Is there any way to create a New Patient List. I am right now counting NP for the month, which is getting old. I have been tracking how many new patients we see per month. Please let me know if this can be done. If not, I will continue counting them by day.

Try this query and just change your dates for your month range. Also, I remember there being a new report in a new version that was to have this report IIRC.

SELECT * FROM PATIENT
WHERE DateFirstVisit >= '2008-06-01'
AND DateFirstVisit < '2008-06-30'

Just switch to version 5.8 to get that report.

Thanks a bunch. My only complaint is that it doesn't add them for you. Still have to count them, but a lot easier than going day by day.

Really? That's an oversight.

If want a count column also of new patients use this custom query

New Patients in Date Range with Date of last visit and Procedure Count
SET @pos=0, @FromDate='2008-06-01' , @ToDate='2008-06-31';
SELECT @pos:=@pos+1 as 'Count', patient.PatNum, LName, FName, DATE_FORMAT(MAX(ProcDate),'%m/%d/%Y') AS 'LastVisit',
COUNT(procedurelog.ProcNum) AS '# Procs Total'
FROM patient
INNER JOIN procedurelog ON procedurelog.PatNum=patient.PatNum
WHERE procedurelog.ProcStatus=2 AND patient.PatStatus=0
AND DateFirstVisit BETWEEN @FromDate AND @ToDate
GROUP BY procedurelog.PatNum
ORDER BY LName;

Nathan

The New Patient report in Ver 5.8.2.0 has the patients numbered on the left side of the report.

nathansparks wrote:If want a count column also of new patients use this custom query

New Patients in Date Range with Date of last visit and Procedure Count
SET @pos=0, @FromDate='2008-06-01' , @ToDate='2008-06-31';
SELECT @pos:=@pos+1 as 'Count', patient.PatNum, LName, FName, DATE_FORMAT(MAX(ProcDate),'%m/%d/%Y') AS 'LastVisit',
COUNT(procedurelog.ProcNum) AS '# Procs Total'
FROM patient
INNER JOIN procedurelog ON procedurelog.PatNum=patient.PatNum
WHERE procedurelog.ProcStatus=2 AND patient.PatStatus=0
AND DateFirstVisit BETWEEN @FromDate AND @ToDate
GROUP BY procedurelog.PatNum
ORDER BY LName;

Nathan

Thanks for this report.

Cathy, scratch that last query I gave you and use this one.