I need to pass a date range into a query. I do not see appsmith having a DateRange Widget so I am planning to use 2 DatePickers.
Current thoughts:
When the first (dpStart) date is picked I want to set it as the Min date for the second (dpEnd) date picker.
When the second date is pick Max date of the first date picker should be set.
In the query I have
and iIFSDistroDate>= ‘{{dpStart.selectedDate}}’
and iIFSDistroDate<= ‘{{dpEnd.selectedDate}}’