$DATE$ returns 'today' at midnight...if you want to run it on Monday's for last week...you can specify that the escalation only run on Monday's....and then setup the timeframe for the report as an offset of $DATE$...make sense?
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Randy Simon Sent: Thursday, August 28, 2008 7:14 AM To: [email protected] Subject: Re: Find issues from days past ** But if I run it during the middle of the week, will it not just go back 7 days giving me a mixed week report? I can see where that works if I run it at Monday Midnight, but not run on Tuesday getting the previous Mon - Sun. _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rohini Prasher Sent: Thursday, August 28, 2008 8:53 AM To: [email protected] Subject: Re: Find issues from days past Hi Randy, You have to convert 1 or 7 to seconds like 1*24*60*60 or 7*60*60. Rohini _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Randy Simon Sent: Thursday, August 28, 2008 6:15 PM To: [email protected] Subject: Find issues from days past I am setting up an escalation to run a report on tickets created the previous day, previous week, and previous month. Is there anyway to do something like $Date$ - 1, or $Date$ - 7? I want to capture the entire previous day, month, or week. I know Crystal can do this, but I do not want to use Crystal at this time. ARS 6.0 CSS 5.0 SQL 2005 Randy Simon Remedy Admin Online Resources Corporation ________________________________________________________________________ STATEMENT OF CONFIDENTIALITY: The information contained in this message or any attachments to this message are intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material as well as being protected from disclosure. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this in error, please contact us immediately and delete the material from any computer. Thank You. ________________________________________________________________________ STATEMENT OF CONFIDENTIALITY: The information contained in this message or any attachments to this message are intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material as well as being protected from disclosure. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this in error, please contact us immediately and delete the material from any computer. Thank You. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ DISCLAIMER: ---------------------------------------------------------------------------- ------------------------------------------- The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any mail and attachments please check them for viruses and defect. ---------------------------------------------------------------------------- ------------------------------------------- __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
