0

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

2
Contributors
1
Reply
2
Views
5 Years
Discussion Span
Last Post by smantscheff
0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.