Filter a gallery to show only dates in the current quarter.
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())
-If(
Mod(Month(Today())-1,3) = 0,
0,
Mod( Month(Today())-1, 3)
),
1
),
EndDate: Date(
Year(Today()),
Month(Today()) + 3-Mod(Month(Today())-1,3),
1
)-1
},
Filter(
'Calendar Dates',
CalendarDate >= StartDate,
CalendarDate <= EndDate
)
)
Output
Gallery shows only rows with a date in the current month. Current date is 6/16/2021.
Title | CalendarDate |
Thursday, April 1, 2021 | 4/1/2021 |
Friday, April 2, 2021 | 4/2/2021 |
Saturday, April 3, 2021 | 4/3/2021 |
Sunday, April 4, 2021 | 4/4/2021 |
Monday, April 5, 2021 | 4/5/2021 |
Tuesday, April 6, 2021 | 4/6/2021 |
Wednesday, April 7, 2021 | 4/7/2021 |
Thursday, April 8, 2021 | 4/8/2021 |
Friday, April 9, 2021 | 4/9/2021 |
Saturday, April 10, 2021 | 4/10/2021 |
Sunday, April 11, 2021 | 4/11/2021 |
Monday, April 12, 2021 | 4/12/2021 |
Tuesday, April 13, 2021 | 4/13/2021 |
Wednesday, April 14, 2021 | 4/14/2021 |
Thursday, April 15, 2021 | 4/15/2021 |
Friday, April 16, 2021 | 4/16/2021 |
Saturday, April 17, 2021 | 4/17/2021 |
Sunday, April 18, 2021 | 4/18/2021 |
Monday, April 19, 2021 | 4/19/2021 |
Tuesday, April 20, 2021 | 4/20/2021 |
Wednesday, April 21, 2021 | 4/21/2021 |
Thursday, April 22, 2021 | 4/22/2021 |
Friday, April 23, 2021 | 4/23/2021 |
Saturday, April 24, 2021 | 4/24/2021 |
Sunday, April 25, 2021 | 4/25/2021 |
Monday, April 26, 2021 | 4/26/2021 |
Tuesday, April 27, 2021 | 4/27/2021 |
Wednesday, April 28, 2021 | 4/28/2021 |
Thursday, April 29, 2021 | 4/29/2021 |
Friday, April 30, 2021 | 4/30/2021 |
Saturday, May 1, 2021 | 5/1/2021 |
Sunday, May 2, 2021 | 5/2/2021 |
Monday, May 3, 2021 | 5/3/2021 |
Tuesday, May 4, 2021 | 5/4/2021 |
Wednesday, May 5, 2021 | 5/5/2021 |
Thursday, May 6, 2021 | 5/6/2021 |
Friday, May 7, 2021 | 5/7/2021 |
Saturday, May 8, 2021 | 5/8/2021 |
Sunday, May 9, 2021 | 5/9/2021 |
Monday, May 10, 2021 | 5/10/2021 |
Tuesday, May 11, 2021 | 5/11/2021 |
Wednesday, May 12, 2021 | 5/12/2021 |
Thursday, May 13, 2021 | 5/13/2021 |
Friday, May 14, 2021 | 5/14/2021 |
Saturday, May 15, 2021 | 5/15/2021 |
Sunday, May 16, 2021 | 5/16/2021 |
Monday, May 17, 2021 | 5/17/2021 |
Tuesday, May 18, 2021 | 5/18/2021 |
Wednesday, May 19, 2021 | 5/19/2021 |
Thursday, May 20, 2021 | 5/20/2021 |
Friday, May 21, 2021 | 5/21/2021 |
Saturday, May 22, 2021 | 5/22/2021 |
Sunday, May 23, 2021 | 5/23/2021 |
Monday, May 24, 2021 | 5/24/2021 |
Tuesday, May 25, 2021 | 5/25/2021 |
Wednesday, May 26, 2021 | 5/26/2021 |
Thursday, May 27, 2021 | 5/27/2021 |
Friday, May 28, 2021 | 5/28/2021 |
Saturday, May 29, 2021 | 5/29/2021 |
Sunday, May 30, 2021 | 5/30/2021 |
Monday, May 31, 2021 | 5/31/2021 |
Tuesday, June 1, 2021 | 6/1/2021 |
Wednesday, June 2, 2021 | 6/2/2021 |
Thursday, June 3, 2021 | 6/3/2021 |
Friday, June 4, 2021 | 6/4/2021 |
Saturday, June 5, 2021 | 6/5/2021 |
Sunday, June 6, 2021 | 6/6/2021 |
Monday, June 7, 2021 | 6/7/2021 |
Tuesday, June 8, 2021 | 6/8/2021 |
Wednesday, June 9, 2021 | 6/9/2021 |
Thursday, June 10, 2021 | 6/10/2021 |
Friday, June 11, 2021 | 6/11/2021 |
Saturday, June 12, 2021 | 6/12/2021 |
Sunday, June 13, 2021 | 6/13/2021 |
Monday, June 14, 2021 | 6/14/2021 |
Tuesday, June 15, 2021 | 6/15/2021 |
Wednesday, June 16, 2021 | 6/16/2021 |
Thursday, June 17, 2021 | 6/17/2021 |
Friday, June 18, 2021 | 6/18/2021 |
Saturday, June 19, 2021 | 6/19/2021 |
Sunday, June 20, 2021 | 6/20/2021 |
Monday, June 21, 2021 | 6/21/2021 |
Tuesday, June 22, 2021 | 6/22/2021 |
Wednesday, June 23, 2021 | 6/23/2021 |
Thursday, June 24, 2021 | 6/24/2021 |
Friday, June 25, 2021 | 6/25/2021 |
Saturday, June 26, 2021 | 6/26/2021 |
Sunday, June 27, 2021 | 6/27/2021 |
Monday, June 28, 2021 | 6/28/2021 |
Tuesday, June 29, 2021 | 6/29/2021 |
Wednesday, June 30, 2021 | 6/30/2021 |