current week's worth

[PeterWijers]

Please try this one.

Works for me. Not sure if you want to use the function to filter from today on.

Greetings

[Jun_KP]

Thank you both Sam and Peter for your inputs! I worked it out based on your inspiration of utilizing both DayOfWeek and WeekNumber functions. Here's the filter for displaying current week of the year:

( Datepart (Date)>= First Day of Current Year ) AND

( ( Datepart(Date)>= Datepart(Now())) OR ( DayOfWeek(Date) <= DayOfWeek(DatePart(Now())) ) ) AND

( WeekNumber(DatePart(Date)) = WeekNumber(DatePart(Now())) )

Jun

[Sam_SAS]

Great! Glad to help 🙂