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
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"