Canvas App- Date Filter

[AVTS]

Trying to display the reports based on the date filter.

Current Setup :

1. DataTable
2. DatePicker1
3. DatePicker2

Datasource is selected in Datatable Items : Dailyinventory.

How to display the filter based table results in the Datatable

[eka24]

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.

[AVTS]

I am getting error ,

[eka24]

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

------------

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.

[AVTS]

Datecolumn is short date,following error . Is this incorrect format ?

[eka24]

Remove the Today () from the formula since it could be picked from Datepicker

------------

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.

[AVTS]

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 )

[zaphod88]

Then try this:
If(DatePicker2.SelectedDate = DatePicker3.SelectedDate,
  Filter(Dailyinventory, 'Created On' = DatePicker2.SelectedDate,
  Filter(Dailyinventory, 'Created On' >= DatePicker2.SelectedDate && 'Created On' <= DatePicker3.SelectedDate )) 

[AVTS]

Is this correct ? i can see duplication of this line ?

Filter(Dailyinventory, 'Created On' = DatePicker2.SelectedDate,

[zaphod88]

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.