Our business week starts on a Monday. I am using the following query to return the year, the week number, the date, the day of the week and the week start date:
SELECT "2027" AS TheYear, DatePart("ww",[TheDate],2,2) AS TheWeekNo,
t_Calendar.TheDate,
t_Calendar.TheDay...