Search String Select in Field with multiple limitations

[nikula22]

Hello all!

After searching through this community and google I am unable to solve my problem.

I would like to be able to select certain weeks depending on the current week.

At the moment my Search String command is the following:

='>=' & (Week(today(2))-12), which returns all above the week 26 at the moment.

But what I would actually want to achieve is at current week (38) to select only weeks 26 to 37.

So '>='  & (Week(today(2))-12) and '<' & Week(today(2)).

Unfortunately, this seems impossible at least with the current approach, any tips on this?

[swuehl]

How does your search string really looks like? I guess it should look like

= '>='  & (Week(today(2))-12) & '<' & Week(today(2))

[nikula22]

Thank you Stefan!

You have been most helpful, I did not really know how this should be defined and this solution worked perfectly.