I’m struggling to get a Server Connect query to filter by a date range. I have a range of filters, based on a drop down. When you select the Dates Between it triggers a Date Range Picker to filter the query. All other filters are working fine.
In my Server Connect I have
and the filters are:
On the page the input parameters for the Server Connect action are:
‘animate4.resourceactivedatefilter.value’ is the expression in both _start and _end
This post suggests there should be start and end formatter options…
…but I can’t see them so my end result is the full date range of 2020-03-16 00:00:00/2020-03-17 23:59:59 gets passed to both $_GET parameters and so the filter doesn’t work. I’m not sure if the start and end formatters should be in the page parameters or the server side variables?
I’m sure there’s something really simple I’m missing but I just can’t see it right now!