My WHERE clause is trying to select rows of a table that have an Order_Date within a given range. That range will always be from a Sunday to the following Saturday. I want to supply the date of the relevant Sunday via a runtime variable, then compute the Saturday on the basis that it is 6 days after the Sunday. Therefore, I want something like this:
Code: Select all
Where Order_Date between :Week_begin_date and :Week_begin_date + 6 days
Can anyone tell me if this is possible and, if it is, how to do it?
I've tried the two expressions that would work in DB2 but neither of them work in Base.