Error when trying to create a Date Filter

I am receiving this error when trying to add a date filter on a timestamp. Not quite sure what this means, but my warehouse is Amazon Redshift if this helps!

The error in the red banner prefaced with Warehouse Error: Query Failed comes from the warehouse, in this case Redshift.
This typically happens when a type cast is applied to the wrong value format.
In this particular case float::8 was being used against a varchar column which contained other non-numeric values such as the word None.