I have a client whose week starts on Monday. since the default week start day in Domo is Sunday, I would like to use beastmode to calculate week numbers with a start day of monday.
I get a validation error every time I try to input a number in the [mode] portion of WEEK(date,[mode]). I'm referencing MySQL 5.5 documentation when inputting the number 5 as my mode. I've tried single quotes, double quotes, no quotes, all get the same error. I've also tried inputting all numbers from 0-7 in the formula and gotten the same error each time. Has anyone else encountered/overcome this?
from MySQL 5.5 Reference on week function

Error in beastmode calc
