# Dataview query with two WHERE statements

**URL:** <https://forum.obsidian.md/t/dataview-query-with-two-where-statements/73984>\
**Category:** Help\
**Tags:** dataview\
**Created:** [December 31, 2023, 10:54pm UTC](https://forum.obsidian.md/t/dataview-query-with-two-where-statements/73984 "2023-12-31T22:54:18Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![sweven](https://forum.obsidian.md/letter_avatar_proxy/v4/letter/s/2bfe46/32.png) [@sweven](https://forum.obsidian.md/u/sweven)\
**Post date:** [January 1, 2024, 7:13pm UTC](https://forum.obsidian.md/t/dataview-query-with-two-where-statements/73984/3 "2024-01-01T19:13:54Z")

</div>

Thank you for the suggestion! But it says “no results to show for list query”.

I’ve tried this query below too, and still can’t get any results. (I verified the LIST FROM is correct.)

**Note** : I use the date format MM-dd-yy in my YAML.

```plaintext
LIST FROM "007 MEDIA 💿/BOOK NOTES 📚" 
WHERE
	dateformat(date-finished,"MM-dd-yy") >= "01-01-23" 
and 
	dateformat(date-finished,"MM-dd-yy") < "01-01-24"

```

---

_[View the full topic](https://forum.obsidian.md/t/dataview-query-with-two-where-statements/73984)._