I’ve been trying out Bases. I singed up to get it in beta and love it. I guess it’s gone live now and it has changed. I have a Base that filters based on a Date field I have “PubDate”. When I set up the base I filtered on PubDate on or after 01/012025 so that it gave me all of this years notes (based on another filter. Now when I put this in, it only gives me one note, and it’s PubDate is not even this year.
Once you’ve done the above, delete everything above this line.
Steps to reproduce
If I make the filter PubDate on 01/01/2025 it finds the file for that day, but after, or on or after do not work.
I know there’s (potentially ?) some type of issue when comparing dates when using the simple filter GUI …
(There’s at least one BR open regarding something similar but with file.mtime/file.ctime: here)
When you select the date to which the key holding the date/time value should be compared to, the date is/was (?) added as a string (as opposed to a date/time value) to the Advanced filter mode…
So instead of comparing 2 dates to each other, you are/were comparing a date to a string… which doesn’t work …
What you could try, if PubDate is a date type of key, would be to switch from the simple filter GUI to the Advanced filter mode (by clicking on the </> next to the trash icon of the condition) and coerce the date string into a date using date(), using something like: