Button to select last 12 Months

[#1]

Hello

I want to create a button which when you click selects the last 12 month in a particular list box. I've tried this by setting the actions on the button and it works fine. However, when I try to use a variable to contain the date 12 months ago it doesn't work. What am I doing wrong? Please see the attached example.

Thanks for your help!

James

[#2 · Accepted solution]

Hi,

You have to write in the second button in the search string this one

='>='&'$(twelveago)'

and it will works

Best wishes

[#3]

This formule is the one i use, when i want to select the past 12 months

='>' & date(addmonths(today(), -13),'YYYYMM') & '<=' & date(today(),'YYYY')&(MonthMin1)  

MonthMin1 is a variable.

I set this variable whit this code:

=text(date(today(),'MM'))

I hope this helps you

Greetz,

Dirk

[#4]

This is a yearmonth construction

Greetz,

Dirk