cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DemosPapa
New Member

Date Range Filtering Issue

Hi Team

I have the bellow filtering on my Gallery. All Filters are working fine with no error but when i choose filtering date range is not showing anything.. any help will be appreciated.

DemosPapa_0-1613069301673.png

This is the part that is not working

DemosPapa_0-1613069527160.png

 

 

4 REPLIES 4
gabibalaban
Super User
Super User

Hi @DemosPapa ,

Please replace Value() function with DateValue() function, as we are talking about dates. Also I guess that LPO_x0020_Created is a date type column and in this case you don't need a conversion (so no DateValue() function).

I guess that colPurchaseOrder is a collection, right ? 

 

Hope it helps !

DemosPapa
New Member

Hi @gabibalaban 
Yes colPurchaseOrder is a collection.
LPO_x0020_Created is a formula value to convert Date Format (Screenshot)

I change the formula as you advise No error again but still not working (Screenshot2)

 

attached also photo of the collection

 

Thank you

@DemosPapa ,

In this case, use datevalue() all over. I thought that is a datetype there.

 

Hi @gabibalaban 

 

Still not working. That's very strange.

All the filtering is working fine this part no. Any other way to achieve it? 

DemosPapa_0-1613076113260.png

 

DemosPapa_3-1613076958981.png

 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,617)