I have an underlying database table where the field type is date, and then in the view I had it set as date, but in the explore if I try to just do a normal filter on it (like an end user would) it fails, because its not a datetime field.
Making it a datetime works (type: date_time, datatype: date) but makes the user interface too fussy with too many options (e.g. in the last 60 seconds...) - what am I missing please? I just want a date filter on a date with days…
This is using BigQuery if that helps.