How do you filter for a time / date range in Excel Extension?
There appears to be no controller that allows Excel Extension to filter for a range of data (eg monitoring water levels) over a specific time / date period.
The only filters that are available are =, < or =, >, > or =
As only one filter condition can be selected the data always has to include either the start of the monitoring period or the end of the monitoring period as one of the boundaries for the data.
I'm looking to be able to set any date / time range within the data but this would need a controller that could accomdate two parameters - for example > date 1 AND < date 2.
Thanks