Default data to monday

Wappler General How To
#1

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

#2

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
#3

SELECT *
FROM yourTable
WHERE DAYOFWEEK(dateCol) = 2;

1 Like
#4

Thanks, I’ll give this a try