Default data to monday

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, …

1 Like

FROM yourTable

1 Like

Thanks, I’ll give this a try