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.

1 Like

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

3 Likes