Unable to apply field filters in native queries

Hi,
I am using Big Query to query from my database.
Whenever I try to add field filters in native queries I always get this error


Any Solution?

Hi @Bhaumik
Do not include the project in the FROM-clause - only the dataset and table.

@Bhaumik Your DateVal column is not a date type. Check Admin > Data Model.