Sheet Action: Show only data for the last year

[Kellerassel]

I have an App that contains data for several years but when accessing a sheet I want to only ever show the last year, while at the same time keeping selections from other sheets. So no Bookmarks.

I use a sheet Action with 

Select values matching search criteria

on my field

%date (date with format DD.MM.YYYY)

and this is my formula:

='>=MonthStart(today(), -12)'

According to the documentation it has to be enclosed in single quotes.  

But as a result it doesn't select anything. 

What am I doing wrong?


Before I had a bookmark using this formula

{<%date={"= %date >= MonthStart(today(), -12)"}>}

and it worked perfectly, so it's not a problem of my data or the MonthStart() formula.

Any help is greatly appreciated.

[Vishal_Gupta]

Hi @Kellerassel 

Can you try this

{<%date={">= $(=Num(YearStart(Max(DateField))))<=$(Num(Max(DateField)))"}>}