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
pgpaCqX1EQuyE.pgp
Description: PGP signature
-------- 2011 Training: http://bestpractical.com/services/training.html