Weekday should start from Monday instead of Sunday

[amrutha_sathish]

I have two fields in calendar weekday and [Week Date]. My requirement is -

My weekday should start with Monday instead of Sunday, Like wise it week date should also get vary - 

PS: [Week date] is made as follows -

[Week_Date_old] & '-' & Right(Year([MonthYear]),2) AS [Week date]

WeekDay	Week Date
Sun	W31 / 05-Aug-23
Mon	W31 / 05-Aug-23
Tue	W31 / 05-Aug-23
Wed	W31 / 05-Aug-23
Thu	W31 / 05-Aug-23
Fri	W31 / 05-Aug-23
Sat	W31 / 05-Aug-23

[rubenmarin · Accepted solution]

Hi, at the begginig of a script there is a FirstWeekDay variable, if your scripts starts weeks on Sunday it should show as:

SET FirstWeekDay=6;

To make weeks start on mondays change it to:

SET FirstWeekDay=0;