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.ORG<mailto: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.com<mailto: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.ORG<mailto: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<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://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"