Mark,
I added these fields to the form several years back and it has been helpful in instances like yours: The values are set from the Arrived Time when the form loads. The user can choose "2" for the Month and "2013" for the Year to see all of the tickets that arrived in February, 2013. HTH, Kelvin From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Brittain, Mark Sent: Friday, March 15, 2013 9:28 AM To: [email protected] Subject: Date Query ** Hi All & TGIF, I want to set up a web report like "give me all the tickets created last week" or "give me all of the tickets created last month". When running the report the query would know today is Friday March 15h and the report is to include all the ticket created between Sunday March 3rd and Saturday March 9th. I know I can do for yesterday, last 7 days, etc. using $DATE$ but don't know if it can be done for last week or last month. ARS 7.6.04 ITSM 7.6.04 Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite - A Time Warner Cable Company [email protected] Office: 315-453-2912 x5335 Mobile: 315-882.5360 ________________________________ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
<<image003.jpg>>
