Automatic Data filter with the help of a Button

[CarlosBach]

Hi !

I would like to generate an automatic filter by  using a Button . It should automaticaly select all weeks of the current year (excluding present week).

Thank you for your help.

Best regards,

Carlos

[marcus_sommer]

Why not providing appropriate fields so that the user could select what's wanted? Beside just creating period-fields like week/month/year within the calendar those fields could be also grouped to W/M/Y TD and similar logic. 

[CarlosBach]

Hi Marcus,

thanks.

I already did that. I just don´t want to use the week filter . the year goes by and the Nr of weeks to filter gets bigger. 

[marcus_sommer · Accepted solution]

I didn't meant this else to create appropriate flags, for example:

-(daynumberofyear(YourDateField) <= daynumberofyear(weekend(today(), -1)) as CompleteWeeksThisYear

This means nearly each kind of date-grouping could be already applied within the calendar as n (nested) flag-fields and/or combined within an extra as-of-table. 

[CarlosBach]

Thanks!

I am new in this world that is why i did not understood what you ment. But it works like i wanted. I do not need a button.