I created an Integer field called "Days Open" and created an Active Link
(execute on Display) with a Set Fields as such:
($TIMESTAMP$ - $Arrival Time$) / 86400
In my Run If, I used the following:
(($TIMESTAMP$ - 'Arrival Time') > 3600) AND ('Status' < "Resolved")
So this only calculates when you are displaying the ticket. Also, it
does not take into consideration any time the ticket is reopened.
Hope this is helpful,
Kelvin
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of BROTONS Oscar
Sent: Tuesday, January 08, 2008 9:24 AM
To: [email protected]
Subject: Re: Incident Age Calculate
Hello,
If you want just to have the age on days you can set a counter to 0 on
each ticket and increase it by one each day with an escalation while the
ticket is open.
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of versicle
Sent: 08 January 2008 01:17
To: [email protected]
Subject: Incident Age Calculate
I'm looking to add a field to the Help Desk form for the age of a ticket
(in
days) from the submit date to the current date. Any ideas on how to
calculate this via workflow?
--
View this message in context:
http://www.nabble.com/Incident-Age-Calculate-tp14679516p14679516.html
Sent from the ARS (Action Request System) mailing list archive at
Nabble.com.
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
************************************************************************
**********************
IMPORTANT: This message is intended exclusively for information
purposes. It cannot be considered as an
official OHIM communication concerning procedures laid down in the
Community Trade Mark Regulations
and Designs Regulations. It is therefore not legally binding on the OHIM
for the purpose of those procedures.
The information contained in this message and attachments is intended
solely for the attention and use of the
named addressee and may be confidential. If you are not the intended
recipient, you are reminded that the
information remains the property of the sender. You must not use,
disclose, distribute, copy, print or rely on this
e-mail. If you have received this message in error, please contact the
sender immediately and irrevocably
delete or destroy this message and any copies.
************************************************************************
**********************
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
