How do you write equality tests to test where current_date() something

I am looking for some advice in how to test where clauses that are based on current_date. Much of the project that I am working on has views that are based on effective date controls. I want to be able to write Equality tests that test that the boundarys are performing correctly as we have cases where the dev have got the < mixed up with <=. Resulting in a boundary error

hi there, you might find a useful schema test on dbt package:

https://github.com/dbt-labs/dbt-utils/blob/master/README.md