is it after hours?

2012-04-24 Thread Brittain, Mark
Hi All, Currently when an incident is created I have a filter that sets the day of the week, and hour of the day. Then there is a second set fields that 'Check Date' = $DATE$ and then checks this against the Business Time Holiday. If it is a holiday then sets the 'Holiday' field to Yes. Then

Re: is it after hours?

2012-04-24 Thread David Sanders
: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark Sent: 24 April 2012 14:15 To: arslist@ARSLIST.ORG Subject: is it after hours? ** Hi All, Currently when an incident is created I have a filter that sets the day of the week, and hour

Re: Number of Cases Created After Hours

2006-08-21 Thread Thomas Bean
rick W Newsgroups: gmane.comp.crm.arsystem.general Sent: Friday, August 18, 2006 13:58 Subject: Re: Number of Cases Created After Hours Any ticket created between 5 PM and 8 AM any day 'Arrival Time' - "01/01/1970") % 86400) = (17 * 3600)) OR ((( 'Arrival Time' - "

Number of Cases Created After Hours

2006-08-18 Thread Kyle Whitley
I am trying to figure out a query that will allow me to see, for a specific site, all cases that were created between 5:00 pm - 8:00 am. I know how to do this for a specific date using the $DATE$ keyword, but how might this be done over a extended date range? This is query I used for a

Re: Number of Cases Created After Hours

2006-08-18 Thread Lucero, Michelle - IST contractor
After Hours I am trying to figure out a query that will allow me to see, for a specific site, all cases that were created between 5:00 pm - 8:00 am. I know how to do this for a specific date using the $DATE$ keyword, but how might this be done over a extended date range? This is query I used

Re: Number of Cases Created After Hours

2006-08-18 Thread Grooms, Frederick W
: Friday, August 18, 2006 1:21 PM To: arslist@ARSLIST.ORG Subject: Number of Cases Created After Hours I am trying to figure out a query that will allow me to see, for a specific site, all cases that were created between 5:00 pm - 8:00 am. I know how to do this for a specific date using the $DATE

Re: Number of Cases Created After Hours

2006-08-18 Thread Kyle Whitley
discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kyle Whitley Sent: Friday, August 18, 2006 1:21 PM To: arslist@ARSLIST.ORG Subject: Number of Cases Created After Hours I am trying to figure out a query that will allow me to see, for a specific site, all cases that were created between 5:00