Filter DateFrom and DateTo and Display on my - Gallery

[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?

[WarrenBelz · Accepted solution]

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

[BIBC-IT]

That worked! Thank you.