In Detailed Reporting for Live Data (adhoc schema's), when trying to set a between filter on a date, the "between" operator is not available (missing).
Production and Preview environments
Reproducing the Issue
Analytics > Analytics > Detailed Reporting
example below uses Event Date as the filter that is being used.
Below is what you would see
Below is what is expected behaviour
This is caused because the date field being used in the filter (in the example give, Event Date) is not configured as a DATE field. Event Date in this example is configured as a text field and therefore the "between" filter operator is not applicable and will not display.
Update the data model to make the affected field a DATE type field.
KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , Problem