Help

Re: Change workweek to Monday -Sunday

1764 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Leslie_Miller
6 - Interface Innovator
6 - Interface Innovator

This formula is very handy
DATETIME_PARSE({WEEKNUM}&’’,‘w’)
however I need the first day of a work week to be and Monday and the last day of the workweek be Sunday
How can I modify this formula?

1 Reply 1

Assuming {WEEKNUM} field is using the WEEKNUM() function:

WEEKNUM(date, [startDayOfWeek])

Returns the week number in a year. You may optionally provide a second argument (either “Sunday” or “Monday”) to start weeks on that day. If omitted, weeks start on Sunday by default. Example:
WEEKNUM(TODAY(), “Monday”)

Otherwise, try using the ISO format for week, which starts on Monday. Instead of 'w' it would be 'W'