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"

Reply via email to