Skip to main content

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'

Hi.

 

Is there a way to set a different tstartDayOfWeek] specifier? I need to use Thursdays. 

 

Any ideas?

 

Reply


Terms & Conditions