Week start date as Sunday

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

In my script, I have formatted the date as below:

([Date]),

DayName([Date]) as TestDay,
Week([Date]) as TestWeek,
Month([Date]) as TestMonth,

And my date table looks like below,

Where the first day of the week starts on Monday - 06^th Feb.

But I need the date table as below,

The first day of week needs to starts on Sunday – 05^th Feb.

I have tried (SET FirstWeekDay=6;)

But it is not working. Can someone help me on it?

Re: Week start date as Sunday

Frank_Hartmann — Mon, 10 Apr 2017 11:30:17 GMT

This might be helpful:

stabben23 — Mon, 10 Apr 2017 12:14:43 GMT

Try to also add 1 in BrokenWeeks:

SET FirstWeekDay=6;
SET BrokenWeeks=1;