Verify day falls in month
You can add the prefix SAFE so the DATE function returns NULL instead of throwing an error.
https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators