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 [email protected]<mailto:[email protected]>
Office 813.978.2192
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Mayfield, Andy L.
Sent: Thursday, October 27, 2011 2:25 PM
To: [email protected]
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:[email protected]] On Behalf Of White, Michael W (Mike)
Sent: Thursday, October 27, 2011 11:39 AM
To: [email protected]
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 [email protected]<mailto:[email protected]>
Office 813.978.2192
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Mayfield, Andy L.
Sent: Thursday, October 27, 2011 12:19 PM
To: [email protected]
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"
