Filter a gallery to show only dates within the previous ‘N’ number of quarters where N is a number specified by the app maker.
Input
Calendar Dates is a SharePoint list with consecutive days starting 1/1/2018 and ending 12/31/2024 (2,557 rows)
| Title | CalendarDate |
| Monday, January 1, 2018 | 1/1/2018 |
| Tuesday, January 2, 2018 | 1/2/2018 |
| Wednesday, January 3, 2018 | 1/3/2018 |
| Thursday, January 4, 2018 | 1/4/2018 |
| Friday, January 5, 2018 | 1/5/2018 |
| … | … |
| Tuesday, December 31, 2024 | 12/31/2024 |
Code
Use this code in the Items property of a gallery.
With(
{
StartDate: Date(
Year(Today()),
Month(Today())-(3*2), //change this number
Day(Today())
)+1,
EndDate: Date(
Year(Today()),
Month(Today()),
Day(Today())
)
},
Filter(
'Calendar Dates',
CalendarDate >= StartDate,
CalendarDate <= EndDate
)
)
Output
Gallery shows only rows with a date in the previous 2 quarters. Current date is 6/16/2021
| Title | CalendarDates |
| Thursday, December 17, 2020 | 12/17/2020 |
| Friday, December 18, 2020 | 12/18/2020 |
| Saturday, December 19, 2020 | 12/19/2020 |
| Sunday, December 20, 2020 | 12/20/2020 |
| Monday, December 21, 2020 | 12/21/2020 |
| … | … |
| Wednesday, June 16, 2021 | 6/16/2021 |
(182 rows)