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]

Thank you for your initiative and effort.

Formula follows

Filter (Dailyinventory, 'Created On' >= DatePicker2.SelectedDate && 'Created On' <= DateAdd(DateAdd(DatePicker3.SelectedDate;1;Days);-1;Milliseconds))

Following error,

[zaphod88 · Accepted solution]

Made an error in pasting as we are using semicolon instead of comma here in Germany. Corrected:

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

[AVTS · Accepted solution]

Great . Looks its giving the correct result. Thank you friend.