Search results

Okay, I see what you're doing here. Now, is there a way to modify this so that, rather than giving me a whole number of days, it will give me the number of hours instead? For our report, we want to show the number of hours between certain milestones.

I'm not exactly sure how to do this. Any chance you can be a little more specific?

We don't really care which doctor is reading the study or whether a doctor is on lunch or anything like that. Our schedule for our offices is always the same. There is always a doctor on site during business hours, but we want to include non-business hours in the calculations, just not weekend...

I know this question has been addressed before in these forums, but I haven't seen a post that asks the question in the same way I am. I have a query that calculates the differences between several different dates/times in my database. For instance, for each patient who comes in, our database...

I have what may be an odd question, but I'm sure there's someone out there that knows how to accomplish this. I have a report that is using DateDiff to calculate the amount of time between two dates. What I want to do is take this one step further. If there is a weekend between the two dates...