Why is my Explore insisting on a datetime for the filter?

[robertlightbody]

Hi,

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.

Thanks,

Rob