Yup....that definitely does it for me... _____
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Wednesday, April 29, 2009 3:22 PM To: [email protected] Subject: Re: Incident Count for a Time Period Each Day ** To use the Modulus you have to force the date field into an integer. You can do that by subtracting the starting date of a Date/Time field (January 1, 1970), which in effect subtracts 0 from your date. The query would be (('Create Date'-"01/01/1970")%86400) > 68400 AND (('Create Date'-"01/01/1970")%86400) < 75600 Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ Longwing Sent: Wednesday, April 29, 2009 2:43 PM To: [email protected] Subject: Re: Incident Count for a Time Period Each Day Or...you could always use the modulus call and say ('Create Date'%86400) > 68400 AND ('Create Date'%86400) < 75600 Where 68400 represents the number of seconds since midnight at 7PM and 75600 is 9PM...and this could be done without creating time fields. But running a quick test on that throws an error about arithmetic error...so I think you would need to have an AL that fires on window open, set the result of ('Create Date'%86400) to an integer field...then look to see if that tmp field is > or <...but it should work. _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Arner, Todd Sent: Wednesday, April 29, 2009 1:29 PM To: [email protected] Subject: Re: Incident Count for a Time Period Each Day That is kind of what I am thinking I'll need to do except I would use a Time field to capture just the time rather than an integer. I just wasn't sure if there was a Time field already buried in the app. So if the time field is named Create Time my query will look like: 'Create Time' >"7:00 PM" and 'Create Time' < "9:00 PM" This will pull in any Incident created between 7:00 PM and 9:00 PM regardless of the date. Thanks to everyone who responded! Todd Arner Great Lakes _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Reiser, John J Sent: Wednesday, April 29, 2009 1:57 PM To: [email protected] Subject: Re: Incident Count for a Time Period Each Day Todd, We did this with a home grown Helpdesk. I added an integer field and used a filter set fields action to put the HOUR($Create Date$) value into it. Then pull a report and look for the tickets with intHour >= 19 AND intHour <=21. HTH, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Arner, Todd Sent: Wednesday, April 29, 2009 2:46 PM To: [email protected] Subject: Incident Count for a Time Period Each Day Is anyone running a report in Incident management 7.0 to count the number of incidents logged during a time period each day? For example, we want to know how many incidents were created between 7:00 PM and 9:00PM during a given week or month. I am not seeing any "time" field to use in the query on the incident form and wanted to check to see if I am just missing it or if there is another way to accomplish the report. My first thought is to add a Time field to the Incident form and populate past Incidents with the time but am wondering if that is the best way to go. TIA, Todd Arner Great Lakes _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
