topic Re: Make a button to select the date range of the previous year in App Development

Make a button to select the date range of the previous year

Magogar — Fri, 02 Feb 2024 11:57:25 GMT

Hello.

How can I make a button to select the date range of the previous year. Everything I've tried so far fails.

=Year(max([fecha]))-1

=(max({<[fecha.autoCalendar.Year]={"$(=Year(max([fecha])))"}>}[fecha]))-1

Thank you!

Re: Make a button to select the date range of the previous year

MatheusC — Fri, 02 Feb 2024 12:11:39 GMT

Hi, @Magogar

try to adjust like:

max([fecha])-1

year(today())-1

Regarts,
Matheus

Re: Make a button to select the date range of the previous year

Magogar — Fri, 02 Feb 2024 12:25:33 GMT

Thanks, but it doesn't work. The dates are in DD/MM/YYYY format, and I want to get the date range of the previous entire year. For the buttons I don't know how to write it.

=Year(max([fecha]))-1

=max(year([fecha.autoCalendar.Year]))-1

=max(year([fecha.autoCalendar.Year])-1)

=max([fecha.autoCalendar.Year])-1

Re: Make a button to select the date range of the previous year

MatheusC — Fri, 02 Feb 2024 12:53:04 GMT

see with the following expression, put your date field

Concat({<[fecha]= {">=$(=Date(YearStart(max([fecha]),-1),'DD/MM/YYYY'))<=$(=Date(Yearend(max([fecha]),- 1),'DD/MM/YYYY'))"}>} DISTINCT date([fecha]), ';' )

Regarts,
Matheus

Re: Make a button to select the date range of the previous year

Magogar — Fri, 02 Feb 2024 13:08:41 GMT

Awesome! it works perfectly. Thanks a lot.