Dear All,
in a query how do I set data only from the last working week? i.e. Monday to Friday without putting dates.
I have this SQL but it doesn't work:
SELECT [2021].Date, [2021].ECO_LABEL, DatePart(weekday, [Date]) Between 2 And 6 AS Weekdays
FROM 2021;
Thanks in advance
best regards
Georg
in a query how do I set data only from the last working week? i.e. Monday to Friday without putting dates.
I have this SQL but it doesn't work:
SELECT [2021].Date, [2021].ECO_LABEL, DatePart(weekday, [Date]) Between 2 And 6 AS Weekdays
FROM 2021;
Thanks in advance
best regards
Georg