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
Search found 8 matches
- Mon Aug 23, 2010 6:40 pm
- Forum: Advanced Topics
- Topic: 91 day report
- Replies: 1
- Views: 3855
- Tue Jul 13, 2010 5:06 am
- Forum: Advanced Topics
- Topic: How many appointments yesterday?
- Replies: 1
- Views: 3810
Re: How many appointments yesterday?
Solved problem. Using
date(logdatetime) = date(curdate()-1)
date(logdatetime) = date(curdate()-1)
- Mon Jun 28, 2010 12:31 pm
- Forum: Advanced Topics
- Topic: Crystal Reports
- Replies: 8
- Views: 15554
Crystal Reports
Hello, has anyone used Crystal Reports with Open Dental? I have a trial version and want to play around.
Thanks
Thanks
- Thu Jun 24, 2010 9:23 am
- Forum: Advanced Topics
- Topic: Sms text messages
- Replies: 5
- Views: 6795
Re: Sms text messages
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...
- Thu Jun 24, 2010 9:19 am
- Forum: Advanced Topics
- Topic: How many appointments yesterday?
- Replies: 1
- Views: 3810
How many appointments yesterday?
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...
- Wed Jun 09, 2010 1:32 pm
- Forum: Advanced Topics
- Topic: How many appoitnemtns did we make today?
- Replies: 3
- Views: 5813
Re: How many appoitnemtns did we make today?
Thanks, found that and just added my 5 points.
- Tue Jun 08, 2010 7:24 pm
- Forum: Main Forum
- Topic: Nobody has requested a web version
- Replies: 34
- Views: 28135
Re: Nobody has requested a web version
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 ...
- Tue Jun 08, 2010 7:13 pm
- Forum: Advanced Topics
- Topic: How many appoitnemtns did we make today?
- Replies: 3
- Views: 5813
How many appoitnemtns did we make today?
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 ...