Kyle, I doubt if a query will be able to filter out weekends. I think you’re going to have to get this info into the call entries themselves.
Here is what I would try: 1. Add an “Hours open” field plus a display-only “Set hours open” flag to your form. 2. Have a filter that runs when “TR.Set hours open” = “Yes”. This filter will calculate how many hours the entry has been open. We use an “artime” function that includes only working hours and excludes weekends and holidays. I’m not sure where we got it. It was here when I got the job. Maybe somebody out there can help us. 3. Query your form and display all the open entries. Do a “Modify All” and set “Set hours open” to “Yes.” This should cause “Hours open” to be calculated on all open entries. (You can also use an escalation to set “Set hours open.”) 4. Do another query that displays all open calls where “Hours open” > whatever. Good luck, Dwayne Martin James Madison University ---- Original message ---- >Date: Thu, 11 Jan 2007 10:56:14 -0500 >From: Kyle Whitley <[EMAIL PROTECTED]> >Subject: How to not include weekends in query? >To: [email protected] > >I am having one of those days, and I can't seem to get this nailed >down. I am running a query to find how many cases have been open for >longer that 48 hrs from 1/4/2007. Our business time is from 8 - 5 and >we are not open on weekends. I know I would have to exclude weekends >from the search, but it is eluding me at this point. Any help would be >appreciated. > >Thanks > >Kyle Whitley >IT System Support Professional >Office of Information and Instructional Technology (OIIT) >Board of Regents of the University System of Georgia > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" Dwayne Martin Computing Support James Madison University
