Thanks everyone for your input. I guess I need to go have my bifocals checked. I didn't see the extra space in my original query.
Todd From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Pierson, Shawn Sent: Thursday, June 05, 2014 2:00 PM To: [email protected] Subject: Re: Use of Modulus in Queries ** So if I combine everyone's queries, I can use something like this to generate a list of all Incidents created outside of normal business hours in the month of May. That's really cool. (('Submit Date'>= "05/01/2014") AND ('Submit Date'< "06/01/2014")) AND (((((('Submit Date' - "1/1/70") % 86400) >= 17 * 3600) AND ((('Submit Date' - "1/1/70" ) % 86400) <= 24 * 3600))) OR ((((('Submit Date' - "1/1/70") % 86400) >= 0) AND ((('Submit Date' - "1/1/70" ) % 86400) <= 6 * 3600))) OR (((('Submit Date'- "01/01/70") % (7*86400)) >= (2*86400)) AND ((('Submit Date'- "01/01/70") % (7*86400)) < ((4*86400))))) Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Hennigan, Sandra Sent: Thursday, June 05, 2014 1:03 PM To: [email protected]<mailto:[email protected]> Subject: Re: Use of Modulus in Queries ** Try this one, starts after hours Incidents at 1800: (('Submit Date'>= "05/01/2014") AND ('Submit Date'< "06/01/2014")) AND (((((('Submit Date' - "1/1/70") % 86400) >= 17 * 3600) AND ((('Submit Date' - "1/1/70" ) % 86400) <= 24 * 3600)))) Change the month/day in (('Submit Date'>= "05/01/2014") AND ('Submit Date'< "06/01/2014")) to get different results. Thank you, Sandra Hennigan Remedy Developer list(ARSList) [mailto:[email protected]] On Behalf Of Arner, Todd Sent: Thursday, June 5, 2014 11:31 AM To: [email protected]<mailto:[email protected]> Subject: Use of Modulus in Queries ** Hello Everyone, In the past, we have used the modulus to run queries to see all Incidents that were created during a specific timeframe, for instance any incident created between 7:00 and 9:00 PM. Below is the query we used: (('Create Date'-"01/01/1970")%86400) > 68400 AND (('Create Date'-"01/01/1970")%86400) < 75600 We haven't had the need to do this for several years and are now trying to run it again. I know this worked in version 6.3, we have since upgraded and are now at version 8.1. Does anyone know if this is still a supported function? When I try to run the query I get the following error: Unexpected character at this location in the query line : at position 16. (ARERR 1581) Any help you can provide is appreciated. Thanks, Todd Arner Great Lakes ________________________________ The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please notify the sender immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ Private and confidential as detailed here<http://www.energytransfer.com/mail_disclaimer.aspx>. If you cannot access hyperlink, please e-mail sender. _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
