What is the right syntax to get the Sum of a certain field between monday 00.01 and sunday 00.00, i.e.
WHERE myDate BETWEEN DAYOFWEEK(monday) AND DAYOFWEEK(sunday)
As you see do I not need this for a given week, but just as a general query. Thank you in advance.
Hi. This is solved. Instead of the DAYOFWEEK() function I used the WEEKDAY() function, i.e.
WHERE WEEKDAY(datum) >= 0
AND WEEKDAY(datum) <= 6
you can go ahead and remove that altogether
0 through 6 are the only possible values
This topic is now closed. New replies are no longer allowed.