Help with Bases filters and formula. Event Logger in Periodic Notes

[jun6lee]

What I’m trying to do

• I’ve created an event logging system where I have entries kept in a folder: “Calendar/Events” under filenames: YYYY-MM-DD-input1, YYYY-MM-DD-input2, etc
• My daily notes are named daily in the standard format: YYYY-MM-DD under the folder “Calendar/Daily/YYYY”
• I have an Events Base embedded in my daily note with a daily view filter.
  • date == this.file.name

… and this works perfectly

---

Now I want to create a view for Weekly/Monthly notes. formats: YYYY-WW and YYYY-MM

Since I am using he journals plugin, these have access to properties:

journal-start-date and journal-start-date which I’m hoping can help me.

What I’ve tried:

I’ve tried an event logging system where I have entries under filenames:

• date == this.file.name
• date >= this.file.journal-start-date
• date >= this.file.(journal-start-date)

only to find myself with unable to parse errors.

Example event file…

---
type: event
event: input
date: 2026-01-07
item: "THE DEATH OF ROBIN HOOD Trailer (2026) Hugh Jackman"
url: "https://youtu.be/GOptnixDp2Q?si=yQtyM8CROLS_4ajL"
context: youtube
---

![](https://youtu.be/GOptnixDp2Q?si=yQtyM8CROLS_4ajL)

Would appreciate some help.

[jun6lee]

I was looking at some of the detailed formula people are using.. including uses of .map | file.backlinks | etc… that I feel may be of use if I can understand what structure I’m looking at with my current formula… (considering it won’t show in the standard view, only in the embed)

So… another offshoot question.. how can I learn what options “file” offers?

file.name and file.backlinks for instance | if it that I can’t access “journal-start-date” because I am pointing my query wrong? It seemed to work with type..

[dawni]

To prevent Bases from interpreting your dashes as arithmetic operators, use the property’s long name:

note["journal-start-date"]

It sounds like you understand date comparisons and can take it from there, but here’s one of your formulas in case it helps to see the syntax in action:

date >= this.note["journal-start-date"]

edit to add:
There’s also a shorthand version for this note if you prefer:

this["journal-start-date"]

which assumes “note”.

[dawni]

@jun6lee

how can I learn what options “file” offers?

File properties are listed here: Bases syntax - Obsidian Help

Also, if you use the UI to create your base, your can type “file” into the properties selector to get a list of options:

… or type “file.” (with the dot) in the formula editor:

[jun6lee]

Thank you.

The key for me here was that it was interpreting dashes as arithmetic operators.

And the shorthand too will be useful going forward.