Plugin release: Vantage - Advanced search builder

Hi- first time posting on this forum and new user so please be gentle :slight_smile:

Absolutely blown away with the power of Obsidian, especially when I found this plugin last night. It’s really helping me learn how to construct my own queries. Thank you so much!

However, I’m stuck…

I’m trying to pull through all unchecked todos from my daily notes, and like @dcb, I’m trying to avoid seeing todos scheduled for current day / future. I wondered if I could use the “yesterday” natural language to always pull through todos up to and including yesterday, rather than today, but it doesn’t look like that works.

Anyone found any way to do this that doesn’t involve entering in a “formal” date manually each day to specify the end of a date range?

Edited to add - my dailies file name format is YYYY-MM-DD. I note that the natural date format looks for DD-MM-YYYY. I’ve tried various combos such as searching by filename using * and also using the date range option:

Using file name search worked as requested in my query below (to find all unchecked todos in March), but the date range option appears to look for files in the DD-MM-YYYY format so returned no results in my case. (Just playing around with searching for dates; doesn’t tackle my “yesterday” request - but fun trying things out!)

file:("2021-03") path:(Dailies)  ((/- \[ \].*.*/))
file:(01-03-2021 OR 02-03-2021 OR 03-03-2021 OR 04-03-2021 OR 05-03-2021 OR 06-03-2021 OR 07-03-2021 OR 08-03-2021 OR 09-03-2021 OR 10-03-2021 OR 11-03-2021 OR 12-03-2021 OR 13-03-2021 OR 14-03-2021 OR 15-03-2021 OR 16-03-2021 OR 17-03-2021 OR 18-03-2021 OR 19-03-2021 OR 20-03-2021 OR 21-03-2021 OR 22-03-2021 OR 23-03-2021 OR 24-03-2021 OR 25-03-2021)  ((/- \[ \].*.*/))

So does this mean that if I use the date range option, it will never do as I want unless I change the format of my file names?

Many thanks