# How do you write equality tests to test where current\_date() something

**URL:** <https://discourse.getdbt.com/t/how-do-you-write-equality-tests-to-test-where-current-date-something/2968>\
**Category:** Archive\
**Created:** [August 31, 2021, 9:13pm UTC](https://discourse.getdbt.com/t/how-do-you-write-equality-tests-to-test-where-current-date-something/2968 "2021-08-31T21:13:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![malcolm\_chambers](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/malcolm_chambers/32/844_2.png) [@malcolm\_chambers](https://discourse.getdbt.com/u/malcolm_chambers)\
**Post date:** [August 31, 2021, 9:13pm UTC](https://discourse.getdbt.com/t/how-do-you-write-equality-tests-to-test-where-current-date-something/2968/1 "2021-08-31T21:13:36Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![s.chaser](https://avatars.discourse-cdn.com/v4/letter/s/ecd19e/32.png) [@s.chaser](https://discourse.getdbt.com/u/s.chaser)\
**Post date:** [September 9, 2021, 12:08am UTC](https://discourse.getdbt.com/t/how-do-you-write-equality-tests-to-test-where-current-date-something/2968/2 "2021-09-09T00:08:28Z")

</div>

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

[https://github.com/dbt-labs/dbt-utils/blob/master/README.md](https://github.com/dbt-labs/dbt-utils/blob/master/README.md)