Filter DateFrom and DateTo and Display on my - Gallery

(0) Share

Report

Posted on by BIBC-IT

I've been trying to filter my gallery by this formula :

Items formula on Gallery :

 'Date Created' >=DateFrom.SelectedDate && 'Date Created'<= DateTo.SelectedDate

DefaultDate Formula :

Today()

So, for example I choose May 1, 2022 to May 4, 2022 - I'd like to display on items on my Gallery from those dates. But, from my filter formula above whats only displaying is from May 1, 2022 - May 3, 2022.

How can I get it to display the items exactly from the selected dates not "between" it?

Also, is there a way to display the way to display the items descending date from the latest date & time to last?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (1)

Report
Hi @BIBC-IT ,

I suspect your fields are date and time, so everything in the end date is after 0:00am, which means you need to add one to the end date

'Date Created' >=DateFrom.SelectedDate && 'Date Created'<= DateAdd(DateTo.SelectedDate,1,Days)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
BIBC-IT 56 on at

Like (0)

Report

That worked! Thank you.

Was this reply helpful? Yes No