identifying a floating date for the current year

[Flafel]

Hi there, and thanks in advance for considering this question.

I need to identify the date for the Saturday closest to Sept. 24 for the current year. For example last year, it was Sept. 25, this year, it would be Sept. 24, and for 2023 it would be Sept. 23, etc. Not 100% how to start this logical conundrum.



Thanks...

[Gicu]

Something like this would work (in a query I added a hard-coded field: SelectedDate: #9/24/2027# that I could change the year to test):

Expr1: IIf(Weekday([SelectedDate]) In (1,2,3),[SelectedDate]-Weekday([SelectedDate]),[SelectedDate]+(7-Weekday([SelectedDate])))