Announcements
Trying to display the reports based on the date filter.
Current Setup :
Datasource is selected in Datatable Items : Dailyinventory.
How to display the filter based table results in the Datatable
Hi @AVTS
On the items property of the DataTable:
Filter (Dailyinventory, DateColumn >= StartDate.SelectedDate && DateColumn <= EndDate.SelectedDate)
------------If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
I am getting error ,
Change the name of the Datapickers to your Datapicker names:
Filter (Dailyinventory, DateColumn >= DatePicker1.SelectedDate && DateColumn <= DatePicker2.SelectedDate)
Also change the DateColumn to your actual Date column name
Datecolumn is short date,following error . Is this incorrect format ?
Remove the Today () from the formula since it could be picked from Datepicker
Hi,
Almost ok. But date selection todate i have to given one more date get previous date data.
Example i have 02.05.2021 is having 10 records. So when i give fom 02.05.2021 to 02.05.2021 no data displaying whereas if i give to date 02.05.2021 to 03.05.2021 then records are displaying
Filter(Dailyinventory, 'Created On' >= DatePicker2.SelectedDate && 'Created On' <= DatePicker3.SelectedDate )
Then try this:If(DatePicker2.SelectedDate = DatePicker3.SelectedDate, Filter(Dailyinventory, 'Created On' = DatePicker2.SelectedDate, Filter(Dailyinventory, 'Created On' >= DatePicker2.SelectedDate && 'Created On' <= DatePicker3.SelectedDate ))
Is this correct ? i can see duplication of this line ?
Filter(Dailyinventory, 'Created On' = DatePicker2.SelectedDate,
Yep. It's a condition: If the picked dates in both pickers are the same, the list is filtered for this date (if DatePicker2 or DatePicker2 does not matter, as it's the same date). Otherwise (if the picked dates are different), the list is filtered for a date range.
it did not pick through error ,
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 85
WarrenBelz 76 Most Valuable Professional
Kalathiya 38 Super User 2026 Season 1
