Filter Gallery using DateRange filter

[Sampath_Kumar]

Hi All,

I am facing an issue when filtering the gallery (Large dataset from CDS) using a date range.

1. I tried like date range of single column and its working fine
             Filter(DataSets,'Valid From'>=DatePicker1.SelectedDate && 'Valid From'<=DatePicker2.SelectedDate )
2. Same like above I want to filter data based on two columns like below, but it's not working

             Filter(DataSets,'Valid From'>=DatePicker1.SelectedDate && 'Valid To'<=DatePicker2.SelectedDate )
Note: Max Date of Valid To column is 12/31/9999 (I updated end year like Today()+10000)

If anyone has any idea please help me with this.

Thanks 🙂

[Sampath_Kumar]

Sorry for late reply. As I am out of station unable to reply to the msgs.

I tried the method which you mentioned still i am unable to do.

I added my data in excel and attaching here. can anyone help me please.

Thank you all 🙂