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
... View more