So Report_current_week:
- Mon
Tue
Wed -- CUT --
Report_previous_weeks:
- Last_week
Two_week
Initial_week (of the month) -- CUT --
Code: Select all
SELECT "Order", "Order_Date" FROM "Orders" where week("Order_Date")= week(Current_date)-1 AND year("Order_Date")= year(Current_date)
Code: Select all
Select *
from "Orders"
where
week("Order_Date") = (SELECT
week("Order_Date")
from "Orders"
where
DATEDIFF('DD', "Order_Date", CURRENT_DATE) = DAYOFWEEK(CURRENT_DATE))
AND
year("Order_Date") = (SELECT
year("Order_Date")
from "Orders"
where DATEDIFF('DD', "Order_Date", CURRENT_DATE) = DAYOFWEEK(CURRENT_DATE))
Code: Select all
...DATEDIFF('DD', "Order_Date", CURRENT_DATE) = DAYOFWEEK(CURRENT_DATE) + 7)
.
.
.
...where DATEDIFF('DD', "Order_Date", CURRENT_DATE) = DAYOFWEEK(CURRENT_DATE) + 7)
Code: Select all
SELECT * from INVOICE WHERE "DATE" >= DayName("Monday") ORDER BY "DATE"
Code: Select all
SELECT *
FROM "Table"
WHERE WEEK("My Date Field") = WEEK(CURRENT_DATE)
AND YEAR("My Date Field") = YEAR(CURRENT_DATE)
Code: Select all
SELECT *,
WEEK("My Date Field")AS "Week",
YEAR("My Date Field") AS "Year"
FROM "Table"
WHERE "Week" = WEEK(CURRENT_DATE)
AND "Year" = YEAR(CURRENT_DATE)