Base filter for "created today"

Hi,

I use Templater to automatically populate a field I created called “Date Created” with today’s date in a format that contains double brackets like this: [[2025-08-07]]. This takes place for every new note that I create, and the Date Created is a hyperlink to the daily note page for the appropriate date.

Now, I need to figure out how to create a Base that shows me all the files “Created today” and it seems easy but I can’t seem to figure it out.

My temporary workaround is as as follows:

  • created a base
  • created a match formula property in the base with this logic - if(file.hasLink(this.file.name), this.file.name, “”)

Result:
This is a temporary workaround because what it does it it will find any file that has a link to today’s date (regardless of whether it was created today or created on another day) and it will display those results.

This means that everything created today will appear here, but a few other items might appear here too if they referenced today’s date.

Is there a cleaner way that I can set my base filters to only show me what was created today based specifically on my Templater-populated field called “Date Created”?

For example, in my Base filter, I would ideally like to just say “Where DATE CREATED” → “IS” → and then put in a value that always references the name of the file where the base is being shown (since I include the base on the template for my Daily Notes page)

Hello.

If the daily note is in YYYY-MM-DD format, the Base below – if placed in the daily note – should pick up any files that contain a property in this format: Date Created: "[[YYYY-MM-DD]]"

views:
  - type: table
    name: Table
    filters:
      and:
        - note["Date Created"].contains(this.file.name)
    order:
      - file.name
      - test
    columnSize:
      file.name: 169

Is this what you want, or closer to what you want? :four_leaf_clover:

This works beautifully @anon80950206! Thank you so much for helping me out. Now I do have one remaining question…

I’ve created a view for everything “Created Today” that is not of “type” “DailyNote” or of type “Meeting” - so my filter clearly says that the type should not be either DailyNote or Meeting.

However, in this view, I’m getting weird behavior. Sometimes it works correctly. And other times, after I click around in the page a bit, the same view starts showing notes that DO have the type property as “Meeting”. I find this really strange since the filter is still in place, but the results change on their own. Do you know what might be going on here? Could it be a bug?

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