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!