Yes, that would give me the last 30 days, but what I am looking for is last 
month. This being March I want the incidents created in February regardless of 
what day in March I run the report.

-----Original Message-----
From: Action Request System discussion list(ARSList) 
[mailto:[email protected]] On Behalf Of Lisa Singh
Sent: Friday, March 15, 2013 10:06 AM
To: [email protected]
Subject: Re: Date Query

> if it can be done for last week or last month.
>

Use this as a qualifier to find tickets logged in the last 30 days - or $DATE$ 
but I always use $TIMESTAMP$ for no particular reason.

'Reported Date+' > $TIMESTAMP$ - (30*24*60*60)

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers 
Are, and have been for 20 years"

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.

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Reply via email to