web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Display date between s...

Power Apps

Answered

Display date between start date and due date

(0) Share

Report

Report

Posted on by dkayt

517

Hi,

how can I simply display all dates between start date and due date in power apps?

E.g:

Start date : 1 april 2022 ;

Due date : 5 april 2022 ;

Dates between : 1 april 2022 , 2 april 2022 , 3 april 2022 , 4 april 2022 , 5 april 2022

Is it possible to make it with Filter(Source,...)

Best Regards.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Assuming you have 2 Datepickers on your screen, filter as follows:

Filter(Datasource,DateColumn>=startDate.SelectedDate && DateColumn <=EndDate.SelectedDate)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Consider Checking My Youtube Channel

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @dkayt ,

The below creates a collection (colDates) of dates:

Clear(colDates); ForAll( Sequence( DateDiff( DateValue("01/04/2022"), DateValue("05/04/2022") ) + 1 ), Collect( colDates, DateValue("01/04/2022") + (Value - 1) ) )

Of course you'll need to replace the static values.

Was this reply helpful? Yes No
dkayt 517 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @eka24
Thanks for replying. I do not have Datepickers. I have a own maded calendar (something like Gallery into gallery).
StartDate and DueDate (their format is Datum) are columns in a SharePoint List with dates.
How can I write the Filter()?

Was this reply helpful? Yes No
dkayt 517 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you @BCBuizer , this one works as expected.

Was this reply helpful? Yes No

Join the conversation