Member Avatar for gedas

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
  • 74 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by smantscheff
Member Avatar for smantscheff

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.