Making a search (Open tickets one week ago)

Hi everybody!

I want to make a search of all open tickets (created) one week ago. That search must take, as reference, the first day as the current day. So, for instance, if I run the search on 09/08, the search must mark 09/01 as the first day and 09/08 as the last day.

I assume this must be done using SQL Query builder, but I am a bit unfamiliar with it.

Can please someone help me out with this?

Thanks in advance!

Best regards

Use string “1 week ago” as date in “Created” search criteria.

RT uses those modules to parse dates:


looking at those modules documentations on cpan, you’ll find allowed search strings.

1 Like


Thanks for the tip!

Best regards