Need a query that returns free time (time units) for a provider over length of time.
For example, Doc A works three 8 hour days a week. That is 24 total hours. We us 15 minute intervals so that would be 96 time units total.
I want to find the number of time units that were free as in cancelled or broken or never scheduled.
If you can direct me to something that is already written and needs modification that would be a plus.
Thanks,
drtmz
Query for free time by provider
Re: Query for free time by provider
Hello Doctor,
Unfortunately, I don't see anything that exactly matches your needs on our website. If you're interested in requesting a custom query, please do so here and we'll contact you with any questions.
Unfortunately, I don't see anything that exactly matches your needs on our website. If you're interested in requesting a custom query, please do so here and we'll contact you with any questions.
Programmer (n.): A machine that turns coffee into code.
Andrew Jansen
Open Dental Software
Software Engineer
andrew@opendental.com
503-363-5432
Andrew Jansen
Open Dental Software
Software Engineer
andrew@opendental.com
503-363-5432