Dynamic bookmark last 3 months

[Anika]

Hi Community,

I would like to set a dynamic bookmark to my app that always selects the last 3 months depending on the current date.

Usually I use such a bookmark to select only the current month and year. In this case, following formula for the month is working pretty good:
=Monat=month(today())

Now I always want to see the current and the two previous months, as of today it would be August, July and June. 

What formula do I need to set?

I've already tried following once but none it working:

=Monat=Month(Addmonths(today(),0))&'|'&Month(Addmonths(today(),-1))&'|'&Month(Addmonths(today(),-2))

=Monat=Month(Addmonths(today(),0))&';'&Month(Addmonths(today(),-1))&';'&Month(Addmonths(today(),-2))

Thanks for your help.

Anika

[Or · Accepted solution]

This is actually a bit tricky, because if you select August, July, and June, you'll get those months from any year, not just the current year. However, if your app only contains data for the current year, or you apply a filter to the year field separately, you can probably use:

=Monat>=Month(Today())-2

[Anika]

I apply a separate filter for the year. 

So your suggetions works in that case 🙂 I'll use it, thanks a lot.

Anika