I need an expression that filters today’s week, but the starting day is Monday and ends on Sunday. I’ve tried this weeknum(today())=weeknum([Date]) but according to this article WEEKNUM() | AppSheet Help Center its starting day is Sunday.
Any suggestions? Thank you.
Perhaps:
WEEKNUM( TODAY() - 1 ) = WEEKNUM( [date] - 1 )
?
It’s still the same result as my first expression.
I should come up with this result, since in my timezone today is monday Aug 16
but got this instead
Please check this conversation… Weeknum(Today()) - #10 by Aurelien
User | Count |
---|---|
45 | |
29 | |
24 | |
21 | |
13 |