donboe — 2014-07-11T03:27:09-04:00 — #1
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.
donboe — 2014-07-11T04:56:29-04:00 — #2
Hi. This is solved. Instead of the DAYOFWEEK() function I used the WEEKDAY() function, i.e.
WHERE WEEKDAY(datum) >= 0
AND WEEKDAY(datum) <= 6
r937 — 2014-07-11T16:52:08-04:00 — #3
you can go ahead and remove that altogether
0 through 6 are the only possible values