Re: Time question
You can use built-in process Application-Bus-Time-Diff to return the number of seconds between two dates excluding weekends/holidays. Need records in Business Time Holidays and Business Time Workdays, two forms Remedy provides with ARS. Each handles multiple records - different kinds of work schedules, different kinds of holiday schedules (including no holidays if that's what you're after). Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 12:19 PM To: arslist@ARSLIST.ORG Subject: Time question ** I'm trying to count the number of weekdays between two dates. Is there a way to easily do this? I've used DATEDIFF in the past, but it counts every day and not just the week days. Thanks, Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Time question
That's essentially it, I was just hoping there was a way without having to use the App-Bus-Time. It looks like that's what I'm going to have to do though. Thanks for the response. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of White, Michael W (Mike) Sent: Thursday, October 27, 2011 11:39 AM To: arslist@ARSLIST.ORG Subject: Re: Time question ** You can use built-in process Application-Bus-Time-Diff to return the number of seconds between two dates excluding weekends/holidays. Need records in Business Time Holidays and Business Time Workdays, two forms Remedy provides with ARS. Each handles multiple records - different kinds of work schedules, different kinds of holiday schedules (including no holidays if that's what you're after). Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 12:19 PM To: arslist@ARSLIST.ORG Subject: Time question ** I'm trying to count the number of weekdays between two dates. Is there a way to easily do this? I've used DATEDIFF in the past, but it counts every day and not just the week days. Thanks, Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Time question
Can someone help me out with the syntax for the Application-Bus-Time2-Diff command? After reading the Configuring manual on page 341 I thought I had it right, but it's giving my an error at line position 49. Application-Bus-Time2-Diff $TicketAssignedDate$ $DATE$ [Normal Work Week] From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of White, Michael W (Mike) Sent: Thursday, October 27, 2011 11:39 AM To: arslist@ARSLIST.ORG Subject: Re: Time question ** You can use built-in process Application-Bus-Time-Diff to return the number of seconds between two dates excluding weekends/holidays. Need records in Business Time Holidays and Business Time Workdays, two forms Remedy provides with ARS. Each handles multiple records - different kinds of work schedules, different kinds of holiday schedules (including no holidays if that's what you're after). Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 12:19 PM To: arslist@ARSLIST.ORG Subject: Time question ** I'm trying to count the number of weekdays between two dates. Is there a way to easily do this? I've used DATEDIFF in the past, but it counts every day and not just the week days. Thanks, Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Time question
Just a guess but I'd try removing the quotes from the field and keyword references Application-Bus-Time2-Diff $TicketAssignedDate$ $DATE$ [Normal Work Week] Todd Arner From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 1:25 PM To: arslist@ARSLIST.ORG Subject: Re: Time question ** Can someone help me out with the syntax for the Application-Bus-Time2-Diff command? After reading the Configuring manual on page 341 I thought I had it right, but it's giving my an error at line position 49. Application-Bus-Time2-Diff $TicketAssignedDate$ $DATE$ [Normal Work Week] From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of White, Michael W (Mike) Sent: Thursday, October 27, 2011 11:39 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Time question ** You can use built-in process Application-Bus-Time-Diff to return the number of seconds between two dates excluding weekends/holidays. Need records in Business Time Holidays and Business Time Workdays, two forms Remedy provides with ARS. Each handles multiple records - different kinds of work schedules, different kinds of holiday schedules (including no holidays if that's what you're after). Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 12:19 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Time question ** I'm trying to count the number of weekdays between two dates. Is there a way to easily do this? I've used DATEDIFF in the past, but it counts every day and not just the week days. Thanks, Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please notify the sender immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Time question
I tried that, but it doesn't seem to like that either. Using Application-Bus-Time-Diff $TicketAssignedDate$ $DATE$ [Normal Work Week] It give an error at position 46. )-: From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd Sent: Thursday, October 27, 2011 1:39 PM To: arslist@ARSLIST.ORG Subject: Re: Time question ** Just a guess but I'd try removing the quotes from the field and keyword references Application-Bus-Time2-Diff $TicketAssignedDate$ $DATE$ [Normal Work Week] Todd Arner From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 1:25 PM To: arslist@ARSLIST.ORG Subject: Re: Time question ** Can someone help me out with the syntax for the Application-Bus-Time2-Diff command? After reading the Configuring manual on page 341 I thought I had it right, but it's giving my an error at line position 49. Application-Bus-Time2-Diff $TicketAssignedDate$ $DATE$ [Normal Work Week] From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of White, Michael W (Mike) Sent: Thursday, October 27, 2011 11:39 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Time question ** You can use built-in process Application-Bus-Time-Diff to return the number of seconds between two dates excluding weekends/holidays. Need records in Business Time Holidays and Business Time Workdays, two forms Remedy provides with ARS. Each handles multiple records - different kinds of work schedules, different kinds of holiday schedules (including no holidays if that's what you're after). Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 12:19 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Time question ** I'm trying to count the number of weekdays between two dates. Is there a way to easily do this? I've used DATEDIFF in the past, but it counts every day and not just the week days. Thanks, Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please notify the sender immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Time question
Try $TIMESTAMP$ NOTE Business Time commands work only with Date/Time fields (not Date fields or Time fields). Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Mayfield, Andy L. [almay...@southernco.com] Sent: Thursday, October 27, 2011 2:44 PM To: arslist@ARSLIST.ORG Subject: Re: Time question ** I tried that, but it doesn’t seem to like that either. Using Application-Bus-Time-Diff $TicketAssignedDate$ $DATE$ [Normal Work Week] It give an error at position 46. )-: From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd Sent: Thursday, October 27, 2011 1:39 PM To: arslist@ARSLIST.ORG Subject: Re: Time question ** Just a guess but I’d try removing the quotes from the field and keyword references Application-Bus-Time2-Diff $TicketAssignedDate$ $DATE$ [Normal Work Week] Todd Arner From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 1:25 PM To: arslist@ARSLIST.ORG Subject: Re: Time question ** Can someone help me out with the syntax for the Application-Bus-Time2-Diff command? After reading the “Configuring” manual on page 341 I thought I had it right, but it’s giving my an error at line position 49. Application-Bus-Time2-Diff $TicketAssignedDate$ $DATE$ [Normal Work Week] From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of White, Michael W (Mike) Sent: Thursday, October 27, 2011 11:39 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Time question ** You can use built-in process Application-Bus-Time-Diff to return the number of seconds between two dates excluding weekends/holidays. Need records in Business Time Holidays and Business Time Workdays, two forms Remedy provides with ARS. Each handles multiple records – different kinds of work schedules, different kinds of holiday schedules (including no holidays if that’s what you’re after). Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 12:19 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Time question ** I’m trying to count the number of weekdays between two dates. Is there a way to easily do this? I’ve used DATEDIFF in the past, but it counts every day and not just the week days. Thanks, Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please notify the sender immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Time question
Maybe that's the problem. I am trying to use a DATE field and DATE keyword. I will give this a try. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Dale Jones Sent: Thursday, October 27, 2011 1:54 PM To: arslist@ARSLIST.ORG Subject: Re: Time question ** Try $TIMESTAMP$ NOTE Business Time commands work only with Date/Time fields (not Date fields or Time fields). Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Mayfield, Andy L. [almay...@southernco.com] Sent: Thursday, October 27, 2011 2:44 PM To: arslist@ARSLIST.ORG Subject: Re: Time question ** I tried that, but it doesn't seem to like that either. Using Application-Bus-Time-Diff $TicketAssignedDate$ $DATE$ [Normal Work Week] It give an error at position 46. )-: From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd Sent: Thursday, October 27, 2011 1:39 PM To: arslist@ARSLIST.ORG Subject: Re: Time question ** Just a guess but I'd try removing the quotes from the field and keyword references Application-Bus-Time2-Diff $TicketAssignedDate$ $DATE$ [Normal Work Week] Todd Arner From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 1:25 PM To: arslist@ARSLIST.ORG Subject: Re: Time question ** Can someone help me out with the syntax for the Application-Bus-Time2-Diff command? After reading the Configuring manual on page 341 I thought I had it right, but it's giving my an error at line position 49. Application-Bus-Time2-Diff $TicketAssignedDate$ $DATE$ [Normal Work Week] From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of White, Michael W (Mike) Sent: Thursday, October 27, 2011 11:39 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Time question ** You can use built-in process Application-Bus-Time-Diff to return the number of seconds between two dates excluding weekends/holidays. Need records in Business Time Holidays and Business Time Workdays, two forms Remedy provides with ARS. Each handles multiple records - different kinds of work schedules, different kinds of holiday schedules (including no holidays if that's what you're after). Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 12:19 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Time question ** I'm trying to count the number of weekdays between two dates. Is there a way to easily do this? I've used DATEDIFF in the past, but it counts every day and not just the week days. Thanks, Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please notify the sender immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Time question
Andy, Although we're running ARS 7.6.3, we still use the old business time processes. The process name for business time difference is Application-Bus-Time-Diff (not Time2). Syntax for it is: Application-Bus-Time-Diff startTime endTime [holidayScheduleName [workdayScheduleName]] (p. 248 in the config. guide) startTime, endTime, holidayScheduleName, and workdayScheduleName can all be field references. No quotes unless you're using a literal value. No brackets. holidayScheduleName matches Schedule Name in Business Time Holidays form and workdayScheduleName matches Name* in Business Time Workdays. In our case, we use year for Schedule Name (one row/record for each year's holidays). We only have 3 workday records - Standard (m-f 8-5) 5x24 and 7x24. A syntax might look like: Application-Bus-Time-Diff $Starttime$ $Endtime$ 2011 Standard (I usually set a character field with YEAR($TIMESTAMP$ and use it instead of 2011; $zzCurrent Year$, for example) I don't know much about it, but as I recall, the new business time processes allow for multiple time segments. 'Not sure how holidays are treated. -HTH Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 2:25 PM To: arslist@ARSLIST.ORG Subject: Re: Time question ** Can someone help me out with the syntax for the Application-Bus-Time2-Diff command? After reading the Configuring manual on page 341 I thought I had it right, but it's giving my an error at line position 49. Application-Bus-Time2-Diff $TicketAssignedDate$ $DATE$ [Normal Work Week] From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of White, Michael W (Mike) Sent: Thursday, October 27, 2011 11:39 AM To: arslist@ARSLIST.ORG Subject: Re: Time question ** You can use built-in process Application-Bus-Time-Diff to return the number of seconds between two dates excluding weekends/holidays. Need records in Business Time Holidays and Business Time Workdays, two forms Remedy provides with ARS. Each handles multiple records - different kinds of work schedules, different kinds of holiday schedules (including no holidays if that's what you're after). Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 12:19 PM To: arslist@ARSLIST.ORG Subject: Time question ** I'm trying to count the number of weekdays between two dates. Is there a way to easily do this? I've used DATEDIFF in the past, but it counts every day and not just the week days. Thanks, Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Time question
Can $PROCESS$ Application-Bus-Time2-Diff be used in escalations? I can get it to work in a filter, but the same syntax gives me an error when trying to use an escalation From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of White, Michael W (Mike) Sent: Thursday, October 27, 2011 2:02 PM To: arslist@ARSLIST.ORG Subject: Re: Time question ** Andy, Although we're running ARS 7.6.3, we still use the old business time processes. The process name for business time difference is Application-Bus-Time-Diff (not Time2). Syntax for it is: Application-Bus-Time-Diff startTime endTime [holidayScheduleName [workdayScheduleName]] (p. 248 in the config. guide) startTime, endTime, holidayScheduleName, and workdayScheduleName can all be field references. No quotes unless you're using a literal value. No brackets. holidayScheduleName matches Schedule Name in Business Time Holidays form and workdayScheduleName matches Name* in Business Time Workdays. In our case, we use year for Schedule Name (one row/record for each year's holidays). We only have 3 workday records - Standard (m-f 8-5) 5x24 and 7x24. A syntax might look like: Application-Bus-Time-Diff $Starttime$ $Endtime$ 2011 Standard (I usually set a character field with YEAR($TIMESTAMP$ and use it instead of 2011; $zzCurrent Year$, for example) I don't know much about it, but as I recall, the new business time processes allow for multiple time segments. 'Not sure how holidays are treated. -HTH Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 2:25 PM To: arslist@ARSLIST.ORG Subject: Re: Time question ** Can someone help me out with the syntax for the Application-Bus-Time2-Diff command? After reading the Configuring manual on page 341 I thought I had it right, but it's giving my an error at line position 49. Application-Bus-Time2-Diff $TicketAssignedDate$ $DATE$ [Normal Work Week] From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of White, Michael W (Mike) Sent: Thursday, October 27, 2011 11:39 AM To: arslist@ARSLIST.ORG Subject: Re: Time question ** You can use built-in process Application-Bus-Time-Diff to return the number of seconds between two dates excluding weekends/holidays. Need records in Business Time Holidays and Business Time Workdays, two forms Remedy provides with ARS. Each handles multiple records - different kinds of work schedules, different kinds of holiday schedules (including no holidays if that's what you're after). Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 12:19 PM To: arslist@ARSLIST.ORG Subject: Time question ** I'm trying to count the number of weekdays between two dates. Is there a way to easily do this? I've used DATEDIFF in the past, but it counts every day and not just the week days. Thanks, Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Time question
--_000_235FF5C46790104687D2103E55C98F046FEA1BEA0FFMXAPEX81PRso_ Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Sorry, I meant to say that it just doesn't run. No errors, just doesn't see= m to run in an escalation. Can $PROCESS$ Application-Bus-Time2-Diff be used in escalations? From: Mayfield, Andy L. Sent: Thursday, October 27, 2011 3:11 PM To: 'arslist@ARSLIST.ORG' Subject: RE: Time question Can $PROCESS$ Application-Bus-Time2-Diff be used in escalations? I can get it to work in a filter, but the same syntax gives me an error whe= n trying to use an escalation From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIS= T.ORG] On Behalf Of White, Michael W (Mike) Sent: Thursday, October 27, 2011 2:02 PM To: arslist@ARSLIST.ORG Subject: Re: Time question ** Andy, Although we're running ARS 7.6.3, we still use the old busi= ness time processes. The process name for business time difference is Appl= ication-Bus-Time-Diff (not Time2). Syntax for it is: Application-Bus-Time-Diff startTime endTime [holidayScheduleName [workdayScheduleName]] (p. 248 in the config. guide) startTime, endTime, holidayScheduleName, and workdayScheduleName ca= n all be field references. No quotes unless you're using a literal value. No brackets. holidayScheduleName matches Schedule Name in Business Time Holidays form = and workdayScheduleName matches Name* in Business Time Workdays. In our = case, we use year for Schedule Name (one row/record for each year's holiday= s). We only have 3 workday records - Standard (m-f 8-5) 5x24 and 7x24. A = syntax might look like: Application-Bus-Time-Diff $Starttime$ $Endtime$ 2011 Standard (I usually set a character field with YEAR($TIMESTAMP$ and use it instead o= f 2011; $zzCurrent Year$, for example) I don't know much about it, but as I recall, the new busine= ss time processes allow for multiple time segments. 'Not sure how holidays= are treated. -HTH Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIS= T.ORG] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 2:25 PM To: arslist@ARSLIST.ORG Subject: Re: Time question ** Can someone help me out with the syntax for the Application-Bus-Time2-Diff = command? After reading the Configuring manual on page 341 I thought I had it righ= t, but it's giving my an error at line position 49. Application-Bus-Time2-Diff $TicketAssignedDate$ $DATE$ [Normal Work We= ek] From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIS= T.ORG] On Behalf Of White, Michael W (Mike) Sent: Thursday, October 27, 2011 11:39 AM To: arslist@ARSLIST.ORG Subject: Re: Time question ** You can use built-in process Application-Bus-Time-Diff to return the number= of seconds between two dates excluding weekends/holidays. Need records in= Business Time Holidays and Business Time Workdays, two forms Remedy provid= es with ARS. Each handles multiple records - different kinds of work sched= ules, different kinds of holiday schedules (including no holidays if that's= what you're after). Mike White EMail michael.wh...@verizon.commailto:michael.wh...@verizon.com Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIS= T.ORG] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 12:19 PM To: arslist@ARSLIST.ORG Subject: Time question ** I'm trying to count the number of weekdays between two dates. Is there a way to easily do this? I've used DATEDIFF in the past, but it c= ounts every day and not just the week days. Thanks, Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are --_000_235FF5C46790104687D2103E55C98F046FEA1BEA0FFMXAPEX81PRso_ Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: quoted-printable ** html xmlns:v=3Durn:schemas-microsoft-com:vml xmlns:o=3Durn:schemas-micr= osoft-com:office:office xmlns:w=3Durn:schemas-microsoft-com:office:word = xmlns:m=3Dhttp://schemas.microsoft.com/office/2004/12/omml; xmlns=3Dhttp:= //www.w3.org/TR/REC-html40headmeta http-equiv=3DContent-Type content= =3Dtext/html; charset=3Dus-asciimeta name=3DGenerator content=3DMicros= oft Word 12 (filtered medium)style!-- /* Font Definitions */ @font-face {font-family:Cambria Math; panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face
Re: Time question
How about DATEDIFF(day, $StartDate$, $EndDate$) - (2 * DATEDIFF(week, $StartDate$, $EndDate$)) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 11:19 AM To: arslist@ARSLIST.ORG Subject: Time question ** I'm trying to count the number of weekdays between two dates. Is there a way to easily do this? I've used DATEDIFF in the past, but it counts every day and not just the week days. Thanks, Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are