Steps to reproduce
- Create a new bases table.
- Add a filter for the view "file.ctime > “2008-01-01”
Did you follow the troubleshooting guide? [Y/N]
Yes
Expected result
The table should list all the notes with the created date after 2008-01-01
Actual result
No results are shown the table
Environment
SYSTEM INFO:
Obsidian version: v1.9.2
Installer version: v1.5.12
Operating system: Darwin Kernel Version 24.5.0: Tue Apr 22 19:54:49 PDT 2025; root:xnu-11417.121.6~2/RELEASE_ARM64_T6000 24.5.0
Login status: logged in
Language: en
Catalyst license: insider
Insider build toggle: on
Live preview: on
Base theme: adapt to system
Community theme: none
Snippets enabled: 0
Restricted mode: on
RECOMMENDATIONS:
none
Additional information
I have tried file.ctime and file.mtime and both show no results, despite the created and modified times for the files being after 01-01-2008.
The only filter that works for these properties are “is empty” or “is not empty”.
I found a similar post which suggested using the dateOnOrAfter() function, but Obsidian gives me the error “Failed to evaluate a filter: Cannot find function dataOnOrAfter”.
The base file:
filters:
and:
- file.folder == "Journal"
views:
- type: table
name: All
filters:
and:
- file.ctime >= "2008-01-01"
order:
- file.name
- tags
- created
columnSize:
file.name: 422
note.tags: 155
note.created: 123
sort:
- column: note.created
direction: DESC
Oh, I also tried created >= "2008-01-01", with the same results.
Examples
With the date filter, I get no results:
Remove the date filter, and the notes show up:
