Relative date search

Hello,

is it possible to make date-searches in RT with relative date?
For example search all open tickets where creation-date is older than 14 days.

best regards
Bernhard

You can enter “14 days ago” into the Created box, or

Created < “14 days ago”

into the Advanced screen of the search builder.On Fri, 6 Mar 2015 5:47 pm Eierschmalz, Bernhard < Bernhard.Eierschmalz@scheppach.com> wrote:

Hello,

is it possible to make date-searches in RT with relative date?

For example search all open tickets where creation-date is older than 14
days.

best regards

Bernhard

Here’s all of the acceptable syntax:

https://metacpan.org/pod/Time::ParseDate#Relative-date-formatsOn Fri, 6 Mar 2015 5:48 pm Alex Peters alex@peters.net wrote:

You can enter “14 days ago” into the Created box, or

Created < “14 days ago”

into the Advanced screen of the search builder.

On Fri, 6 Mar 2015 5:47 pm Eierschmalz, Bernhard < Bernhard.Eierschmalz@scheppach.com> wrote:

Hello,

is it possible to make date-searches in RT with relative date?

For example search all open tickets where creation-date is older than 14
days.

best regards

Bernhard

You can enter “14 days ago” into the Created box, or

Created < “14 days ago”

into the Advanced screen of the search builder.

Note that despite how it reads in English, 'Created < “14 days ago”'
means tickets that were created more than 14 days ago. That is, it
is read as “Take the point in time 14 days ago; find tickets whose
creation date is less than (prior to) that point.”

The connotation of the word “ago” in combination with less than /
greater than is often a point of confusion.

  • Alex