How can I change a week to start on Monday instead of Sunday? ( DateTrunc Truncate Date )

Currently in Sigma if I truncate a date to a week – the week starts on a Sunday. Is there any way I can switch the week start to Monday? This is how our organization measures a week.

2 Likes

Hey Zachary,

Great question! I know this question has come up with other Sigma users Attached below is a quick formula you can use to change the start of the week date to Monday!

If(Weekday([Target Date]) > 1, DateAdd(“day”, 1, DateTrunc(“week”, [Target Date])), DateAdd(“day”, -6, DateTrunc(“week”, [Target Date])))

Hope this helps,

-Ryan

4 Likes

The DateTrunc function now officially accepts “week_starting_monday” for the precision field. To use:

DateTrunc("week_starting_monday", [Date])
2 Likes