Button to Select data available weeks to date

[#1]

Good afternoon

I need to create a button which when pressed selects all of the available weeks for the present year, i.e If I were to press the button today it would select the first 19 weeks, If I press it next week it would select the first 20 weeks.

Within a button you can set an action "select in field" where im using a week of a created date and <=19 in the criteria and this works fine. However using a function like =$(<=week(today())) the button stops working.

Any help would be appreciated.

Regards

Shaun

[Anonymous · Accepted solution]

Hi Shaun,

I think I found it:

Try this :          = '<=' & Week(today())

Good luck.

[#3]

ooo I like it. That works perfectly.

Thanks