Start Of Week (Date value)

1

I need to determine the date of the first day of the week that starts on a Monday, in Date type. I tried the following but get Error: Can’t convert to date

date(weekstart(today())+1, 'M/d/yy')

if I do the following it works, what is wrong with the above?

format(weekstart(today())+1, 'M/d/yy')

2

The date() function is reverse to the format() function. It expects a text date and converts it to a number date, while the format() function does the opposite.

See also the web help on the date() function.

3

Ended up using the following

format(weekstart(today())-6, 'MM/dd/yy')
1 Like