I set up a schedule table internally that populated monday trough friday in the header (based on the current date)
Some of our people want it to load on Monday always.
How do I make a data query pick the monday of this week? MYSQL
I set up a schedule table internally that populated monday trough friday in the header (based on the current date)
Some of our people want it to load on Monday always.
How do I make a data query pick the monday of this week? MYSQL
The MYSQL DAYOFWEEK() function is used to retrieve the index of the weekday of the given date. This function returns a numerical value which can be either one of the following: 1 for Sunday, 2 for Monday, …
SELECT *
FROM yourTable
WHERE DAYOFWEEK(dateCol) = 2;
Thanks, I’ll give this a try