The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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?
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'