Button for YearToDate selection

[MCmiranda]

Hello smarties,

I want to make a button for the selection of the last 12 months and a selection of the last month.

I find a variety of functions, but don't know which one to use.. Anybody can set me up with this?

I've set Action:

Select value in a field -> field -> name is 'Date Check' 
Now I have to put in a value.. To get the last 12 months from today.

[GaryGiles · Accepted solution]

Try this:

=Concat({1<[Date Check]={"<$(=Today())>$(=AddMonths(Today(),-12))"}>} [Date Check],';')

[QFabian]

>=addmonths(yourdate, -12) <= yourdate

[MCmiranda]

Thank you, this is awesome!

[MCmiranda]

Hi Gary,

I believed I could figure the code for the selection of this month myself, for the other button.. But I can't

I tried:

=Month(Today())

=AddMonths(Today(),1)