No, you need to use both date and time since the crate time is a Date Time field.
-----Original Message----- From: Arner, Todd <[email protected]> To: [email protected] Sent: Wed, 29 Apr 2009 3:28 pm 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 ** v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} -- --> 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"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _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"

