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"

Reply via email to