web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to get the records...

Power Apps

Unanswered

How to get the records between two date range in Power apps gallery

(0) Share

Report

Report

Posted on by raah0705

20

Hello Everyone,

I want to filter the gallery data between two date range in Power apps. Data should be filter from start date and end date.

I tried below code.

but it will not filter the data for today's record. It filter the data till yesterday's records.

I have also tried to use the date converted into number format and then compare those date numbers.

but this logic also would not work for me.

Please help to resolve this date filter issue between two start date and end date range.

Thank you for your answer.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Sort by

vivekravi 241 on at

Like (0)

Report
Copy link

Link copied!
Hello,

Filter( SPL List, CreatedDate >= fromDate.SelectedDate && CreatedDate <= ToDatePicker.SelectedDate)

this should have worked. So are you getting any error in your formula?

Was this reply helpful? Yes No
raah0705 20 on at

Like (0)

Report
Copy link

Link copied!

Hi @vivekravi ,

Thanks for your reply.
I am using the same formula, but this formula is not filtering the today's date data from the collection.
It filter till yesterday date but not filtering today's date records.

Thanks for your support.

Was this reply helpful? Yes No
vivekravi 241 on at

Like (0)

Report
Copy link

Link copied!
Weird. Maybe tryo to add the Today function in the filter

Filter( SPL List, CreatedDate >= (fromDate.SelectedDate|| Today() )&& (CreatedDate <= ToDatePicker.SelectedDate|| Today()))

Was this reply helpful? Yes No
raah0705 20 on at

Like (0)

Report
Copy link

Link copied!

Hi @vivekravi ,

Yes, Its weird for me as well. No, it is not working Today() function in filter formula.

Was this reply helpful? Yes No

Join the conversation