Syntax for excluding files with string as value in data view

Things I have tried

What I’m trying to do

I’m trying to make a dataview query to show only weekdays.
Currently days have a “day-of-week” value represented as ddd (sun for sunday) and I’m trying to exclude/only include files that have a day-of-week value of “fri” or “sat”.

I know this is a very simple question but i couldn’t find a specific syntax for this except a general “use Where”

will this work?
insert in FROM a suitable path or folder or leave blank to include to entire vault

TABLE
FROM ""
WHERE !contains(days-of-week, "fri") or !contains(days-of-week, "sat")

Yes! Thank you.

I was missing the contains() function

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.