Open Dental Forum

I noticed that the patient table has a field admitdate. I was wondering where this data is entered at/pulled from. Ours seems to be always the default 1/1/0001 for every patient.

Thanks, and yes we are still using MySQL for now. I think I'm going to really miss it when we have to switch to Oracle.

I'm trying to write a query to identify duplicate patient records. Basically I want to pull patients from the same table that have the same fname, lname, and DOB but have different unique ids. My first try was: select d2.patnum as id,d2.patnum,d2.lname,d2.fname,d2.birthdate from patient as d1, patie...