Weeknum() filter

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 )

?

1 Like

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
image

but got this instead
image

Please check this conversation… Weeknum(Today()) - #10 by Aurelien

3 Likes