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

[AVTS]

it did not pick through error ,

[zaphod88]

Missed a bracket, sorry:
If(DatePicker2.SelectedDate = DatePicker3.SelectedDate,
  Filter(Dailyinventory, 'Created On' = DatePicker2.SelectedDate),
  Filter(Dailyinventory, 'Created On' >= DatePicker2.SelectedDate && 'Created On' <= DatePicker3.SelectedDate )) 

[AVTS]

thanks now error disappear but results are same i have to select the 03.05.2021 to display the 02.05.2021 records.

[AVTS]

Hello Friends,

What wrong in this code ? i see most of the users are referring the same whereas its not picking as per given date. instead i have to give additional one more day to get previous day data...

Filter('Dailyinventory', 'Created On' >= (DatePicker2.SelectedDate) && ('Created On') <= (DatePicker3.SelectedDate))

Need your view on this ..

[eka24]

Show sample data. Indicate the result you expect and the result you are actually getting.

That would help deal with it. 

This is the first code i gave which is same as you are quoting:

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]

Find follows,

Trying to see the records betwen 02/05/2021

Below is the result with future date ..

[zaphod88]

Maybe the time zones of PowerApps and your data source (Sharepoint?) are different?

[AVTS]

Datasource is Dataverse table shows correct date.

[zaphod88]

Hm... I have no clue what the problem is here. Maybe @RandyHayes can help?

[zaphod88]

Ok, I found it. Although not shown in DatePicker, there seems to be a time included, I guess at midnight. So you have to change it to:

Filter (Dailyinventory, DateColumn >= StartDate.SelectedDate && DateColumn <= DateAdd(DateAdd(EndDate.SelectedDate,1,Days),-1,Milliseconds))