How can i see what days I worked?

[AussieDentistThird]

I shut down my practice a few years ago, and there are the odd unpaid appointments that have been made

I would like a list of appointments , so i can search for the last 3 years, and have a list of appointments

How can i do this?

I dont want to look at and move the calendar manually!!

[Tom Zaccaria]

Try this;
drtmz


/*List of patients with appointments in the past with primary insurance carrier listed
Also lists sum of fees for day and insurance type by Taylor M modified*/

SELECT Time_Format((time(a.AptDateTime)),"%h:%i %p") as AppTime,
p.PatNum,
a.ProvNum,
a.ProvHyg,
TIMESTAMPDIFF(YEAR,p.Birthdate,CURDATE()) as age,
substring(WirelessPhone,1,14) as'Cell' ,
substring(p.HmPhone,1,14) as 'HPhone',
substring(a.ProcDescript,1,20) as Precedures
FROM appointment a
INNER JOIN patient p ON p.PatNum=a.PatNum /*just in case we need field from patient table*/
INNER JOIN procedurelog pl ON a.AptNum=pl.AptNum AND (DATE(a.AptDateTime)
BETWEEN Curdate()+Interval -365 Day AND Curdate()+Interval -100 Day) /*change time frame in days here*/
AND a.AptStatus IN (2) /*this number gives completed apointments only*/
LEFT JOIN patplan pp ON pp.PatNum=p.PatNum AND ORDINAL=1/*by current primary insurance*/
LEFT JOIN inssub iss ON pp.InsSubNum=iss.InsSubNum
LEFT JOIN insplan ip ON ip.PlanNum=iss.PlanNum
LEFT JOIN carrier ON carrier.CarrierNum=ip.CarrierNum
GROUP BY a.AptNum
ORDER BY a.AptDateTime;