Sheet Action: Show only data for the last year

Kellerassel — Sat, 16 Nov 2024 16:52:05 GMT

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.

Re: Sheet Action: Show only data for the last year

Vishal_Gupta — Wed, 05 Jan 2022 08:56:04 GMT

Hi @Kellerassel

Can you try this

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

topic Sheet Action: Show only data for the last year in App Development

Sheet Action: Show only data for the last year

Re: Sheet Action: Show only data for the last year