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?
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.