From the screenshot provided, you are using the list view with editable.
The datasource is microflow.
You can change everything to and use DataGrid2. Where you can achieve direct filters on date >, >=, <,<=, and equal.
For now, to match with what you have done, we can do the below steps
Create a SearchFilter entity that can save the SearchDeliveryDate.
Let the SearchFilter bet the datasource for the data view
Add a date-picker widget to hold the SearchDeliveryDate.
Add list view inside the dataview.
Add Microflow as the datasource. SF_CreateSearchFilter
On changing the date configure the on-change microflow as below
The reason we are refreshing the object is to trigger the DS flow for the list view.
The microflow for the list is below:
If you are very particular about 3 months, 6 months filters:
Create a SearchFilter entity
Attribute = ThreeMonths à Datatype = Boolean à default value = false
Attribute = SixMonths à Datatype = Boolean à default value = false
Create a button that works for 3months and another for 6months
OnClick on button for 3months
Run a microflow – change the ThreeMonths attribute SearchFilter object, to true and refresh the page object
Datasource of the List View should be like
If the SearchFilter – Threemonths attribute is true
Loop the cargonlist
If Delivered date falls below three months from now then add to valid list and later output the valid list
If the SearchFilter – Threemonths attribute is false
Retrieve all the cargo list that are just delieved.
Hope you find it helpful!!!