Dwayne, In step 2, why use "TR.Set hours open" instead of just "Set hours Open" in the filter condition?
<peeve> I'm still waiting/trying to find a situation where the TR value is required and 100% accurate (however, I have no issue with using DB when needed). So far, in everything I've come up with or seen, it is either not necessary or not 100% accurate. Given the confusion that usually surrounds it, I would prefer to see it gone. Basically, If you think you need the TR value, you are probably over complicating your situation, or not getting perfect results. Naturally, I am willing to be proved wrong on this. :-) </peeve> Regards, Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach "Dwayne Martin" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 01/12/2007 06:51 AM Please respond to [email protected] To [email protected] cc Subject Re: How to not include weekends in query? 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 ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
