hi guys,

i am trying to write a query that would basically display me pas 4 week, however if lets say today is Wednesday the pas for week would have to start from last Friday, none the less if i have to run the query on monday i would want to see the last 4 week from the last week.
to conclude this what i want is the past for week, but not including current week.

any help will be appreciated.

thank you

What have you tried so far? Have a look at the to_days() and the round() function which may help to solve your problem.