I know, and I looked at the docs, but I can't figure out how to do what I want. I figured someone on the list must have figured out a way to get last months report easily, regardless of how long it is into the current month.
After spending more time on this, it turns out Created >= 'first of last month' doesn't work either. It's not documented to work, but it did return the results I expected. I found out the only reason it did, was because there are no tickets in the queue I queried older than a month anyway. :) The problem is, I can't figure out if it's possible to combine a relative date with other criterion. For instance, 'last month' returns exactly one month ago, so since today is Aug 4th, it returns July 4th, although I need July 1st @midnight. Any ideas? ---------- John Alberts Cloud Optimization Engineer Ex Libris (USA) Inc. 1350 E. Touhy Ave. Suite 200 East Des Plaines, IL 60018 Phone: 1-219-979-6560 Follow Ex Libris on Twitter: @exlibrisgroup <http://twitter.com/ExLibrisGroup> On 8/4/11 9:42 AM, "Kevin Falcone" <falc...@bestpractical.com> wrote: >On Thu, Aug 04, 2011 at 01:29:53AM +0000, John Alberts wrote: >> Hi. I've found quite a few examples and documentation about using >>relative dates to search >> RT; however, for the life of me, I can't figure out how to use >>relative dates to get a list of >> tickets that were created last month. >> I would like to create and save a search for our secretary, so she >>can easily get a list of >> tickets in a specific queue that were created last month. Without >>using relative dates, >> getting the tickets in this queue that were created last month is >>not a problem. This works >> perfect. > >We use the CPAN module Time::ParseDate, so you can use whatever syntax >it supports. >http://search.cpan.org/~muir/Time-modules-2011.0517/lib/Time/ParseDate.pm > >-kevin > >> Queue = 'Root Cause Analysis Forms' AND ( Created >= '07-01-2011' >>AND Created < '08-01-2011' >> ) >> Using relative dates, I tried these, and none work how I want. >> # This works, but the end date isn't relative >> Queue = 'Root Cause Analysis Forms' AND ( Created >= 'first of last >>month' AND Created < >> '08-01-2011' ) >> # Returns 0 results >> Queue = 'Root Cause Analysis Forms' AND ( Created >= 'first of last >>month' AND Created < >> 'first of this month' ) >> # Returns 0 results >> Queue = 'Root Cause Analysis Forms' AND ( Created >= 'first of last >>month' AND Created < >> 'first of the month' ) >> # Returns 0 results >> Queue = 'Root Cause Analysis Forms' AND ( Created >= 'first of last >>month' AND Created < >> 'this month' ) >> #Returns 0 results >> Queue = 'Root Cause Analysis Forms' AND ( Created >= 'first of last >>month' AND Created <= >> 'end of last month' ) >> Any help appreciated. >> Thanks >> John > >> >> -------- >> 2011 Training: http://bestpractical.com/services/training.html > > >-------- >2011 Training: http://bestpractical.com/services/training.html -------- 2011 Training: http://bestpractical.com/services/training.html