Open Dental

Hello, I would like to know which patient accounts turn 91 days old to send to our collection process. I see a 30, 60 & 90 day field on the patient table, but is there a way to determine the date that the account turned the age (91 days in this case) from these fields?
thanks

Solved problem. Using

date(logdatetime) = date(curdate()-1)

Hello, has anyone used Crystal Reports with Open Dental? I have a trial version and want to play around.

Thanks

We are using DemandForceD3.com to handle both email and text messaging. In addition to the permission based nature of the service, it also collects reviews and surveys to upload to google, improving the score when you search for 'cityname' dentist. Service automatically detects cell phone numbers an...

Hello, we send an email to our scheduling team at 10, noon and 2 to update them on how many appointments have been made that day. Between 2 and 6 we have more appointments and will count those the next day for our daily email under how many appointments were made yesterday. I am using: select * from...

Thanks, found that and just added my 5 points.

We have been using a hosted server for over 5 years now. With all the 'improvements' in MS and hacking, trying to secure a multi location database application is beyond my skill set. Further, I don't have to worry about new servers and operating systems, its part of the monthly fee. Further, if the ...

Hello, Just switched to Open Dental from Practice Works. I would like to know how many appointments we made today for future dates, total and recare. I would also like to drill down further and know if these appointments were from people who came in for an appointment, or if they were from our long ...