Date from a date field to today
Here is my query, but it's not calculating correctly. I'm trying to determine how many weekdays have occurred between "23-24 Start Date" and today, but I'm getting a number that's much too high.
SELECT
"Q_DataWalls_Time-Off_23-24"."Name",
DATEDIFF(WEEKDAY, "23-24 Start Date", CURDATE()) AS "Weekdays Worked"
FROM "Q_DataWalls_Time-Off_23-24"