Power Apps Filter Gallery By Dates In Current Quarter

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)

TitleCalendarDate
Monday, January 1, 20181/1/2018
Tuesday, January 2, 20181/2/2018
Wednesday, January 3, 20181/3/2018
Thursday, January 4, 20181/4/2018
Friday, January 5, 20181/5/2018
Tuesday, December 31, 202412/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.

TitleCalendarDate
Thursday, April 1, 20214/1/2021
Friday, April 2, 20214/2/2021
Saturday, April 3, 20214/3/2021
Sunday, April 4, 20214/4/2021
Monday, April 5, 20214/5/2021
Tuesday, April 6, 20214/6/2021
Wednesday, April 7, 20214/7/2021
Thursday, April 8, 20214/8/2021
Friday, April 9, 20214/9/2021
Saturday, April 10, 20214/10/2021
Sunday, April 11, 20214/11/2021
Monday, April 12, 20214/12/2021
Tuesday, April 13, 20214/13/2021
Wednesday, April 14, 20214/14/2021
Thursday, April 15, 20214/15/2021
Friday, April 16, 20214/16/2021
Saturday, April 17, 20214/17/2021
Sunday, April 18, 20214/18/2021
Monday, April 19, 20214/19/2021
Tuesday, April 20, 20214/20/2021
Wednesday, April 21, 20214/21/2021
Thursday, April 22, 20214/22/2021
Friday, April 23, 20214/23/2021
Saturday, April 24, 20214/24/2021
Sunday, April 25, 20214/25/2021
Monday, April 26, 20214/26/2021
Tuesday, April 27, 20214/27/2021
Wednesday, April 28, 20214/28/2021
Thursday, April 29, 20214/29/2021
Friday, April 30, 20214/30/2021
Saturday, May 1, 20215/1/2021
Sunday, May 2, 20215/2/2021
Monday, May 3, 20215/3/2021
Tuesday, May 4, 20215/4/2021
Wednesday, May 5, 20215/5/2021
Thursday, May 6, 20215/6/2021
Friday, May 7, 20215/7/2021
Saturday, May 8, 20215/8/2021
Sunday, May 9, 20215/9/2021
Monday, May 10, 20215/10/2021
Tuesday, May 11, 20215/11/2021
Wednesday, May 12, 20215/12/2021
Thursday, May 13, 20215/13/2021
Friday, May 14, 20215/14/2021
Saturday, May 15, 20215/15/2021
Sunday, May 16, 20215/16/2021
Monday, May 17, 20215/17/2021
Tuesday, May 18, 20215/18/2021
Wednesday, May 19, 20215/19/2021
Thursday, May 20, 20215/20/2021
Friday, May 21, 20215/21/2021
Saturday, May 22, 20215/22/2021
Sunday, May 23, 20215/23/2021
Monday, May 24, 20215/24/2021
Tuesday, May 25, 20215/25/2021
Wednesday, May 26, 20215/26/2021
Thursday, May 27, 20215/27/2021
Friday, May 28, 20215/28/2021
Saturday, May 29, 20215/29/2021
Sunday, May 30, 20215/30/2021
Monday, May 31, 20215/31/2021
Tuesday, June 1, 20216/1/2021
Wednesday, June 2, 20216/2/2021
Thursday, June 3, 20216/3/2021
Friday, June 4, 20216/4/2021
Saturday, June 5, 20216/5/2021
Sunday, June 6, 20216/6/2021
Monday, June 7, 20216/7/2021
Tuesday, June 8, 20216/8/2021
Wednesday, June 9, 20216/9/2021
Thursday, June 10, 20216/10/2021
Friday, June 11, 20216/11/2021
Saturday, June 12, 20216/12/2021
Sunday, June 13, 20216/13/2021
Monday, June 14, 20216/14/2021
Tuesday, June 15, 20216/15/2021
Wednesday, June 16, 20216/16/2021
Thursday, June 17, 20216/17/2021
Friday, June 18, 20216/18/2021
Saturday, June 19, 20216/19/2021
Sunday, June 20, 20216/20/2021
Monday, June 21, 20216/21/2021
Tuesday, June 22, 20216/22/2021
Wednesday, June 23, 20216/23/2021
Thursday, June 24, 20216/24/2021
Friday, June 25, 20216/25/2021
Saturday, June 26, 20216/26/2021
Sunday, June 27, 20216/27/2021
Monday, June 28, 20216/28/2021
Tuesday, June 29, 20216/29/2021
Wednesday, June 30, 20216/30/2021