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"_ _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"
