Skip to content

Instantly share code, notes, and snippets.

@dannberg
Last active January 7, 2025 05:55
Show Gist options
  • Save dannberg/48ea2ba3fc0abdf3f219c6ad8bc78eb6 to your computer and use it in GitHub Desktop.
Save dannberg/48ea2ba3fc0abdf3f219c6ad8bc78eb6 to your computer and use it in GitHub Desktop.
Dann Berg's Daily Note Template for Obsidian. Uses Dataview & Templater plugins. Should be saved as a Markdown file in Obsidian. Read the full tour: https://dannb.org/blog/2022/obsidian-daily-note-template/
---
created: <% tp.file.creation_date() %>
---
tags:: [[+Daily Notes]]
# <% moment(tp.file.title,'YYYY-MM-DD').format("dddd, MMMM DD, YYYY") %>
<< [[Timestamps/<% tp.date.now("YYYY", -1) %>/<% tp.date.now("MM-MMMM", -1) %>/<% tp.date.now("YYYY-MM-DD-dddd", -1) %>|Yesterday]] | [[Timestamps/<% tp.date.now("YYYY", 1) %>/<% tp.date.now("MM-MMMM", 1) %>/<% tp.date.now("YYYY-MM-DD-dddd", 1) %>|Tomorrow]] >>
---
### πŸ“… Daily Questions
##### 🌜 Last night, after work, I...
-
##### πŸ™Œ One thing I'm excited about right now is...
-
##### πŸš€ One+ thing I plan to accomplish today is...
- [ ]
##### πŸ‘Ž One thing I'm struggling with today is...
-
---
# πŸ“ Notes
- <% tp.file.cursor() %>
---
### Notes created today
```dataview
List FROM "" WHERE file.cday = date("<%tp.date.now("YYYY-MM-DD")%>") SORT file.ctime asc
```
### Notes last touched today
```dataview
List FROM "" WHERE file.mday = date("<%tp.date.now("YYYY-MM-DD")%>") SORT file.mtime asc
```
@alwant
Copy link

alwant commented Aug 26, 2024

If you're running Obsidian on ChromeOS via Linux virtual machine, you need you replace <% tp.file.creation_date() %> with <% tp.file.last_modified_date("YYYY-MM-DD hh:mm") %> or you'll consistently get 1970-01-01 01:00

@1artist
Copy link

1artist commented Sep 23, 2024

I am getting the Parsing error shown below circled in RED after copying the RAW code from the Github page and pasting it into my Daily Note template file located in Extra/Journal/Template, Daily Note file. Can anybody in this forum please clarify to me why this error is being generated? It says "Expected one of the following:" but I do not know what it is referring to. I am using the latest Obsidian/Templater on a Windows 10 PC. Any advice welcome.

Parsing Error

### Notes created today
Dataview: Error: 
-- PARSING FAILED --------------------------------------------------

> 1 | List FROM "" WHERE file.cday = date("<%tp.date.now("YYYY-MM-DD")%>") SORT file.ctime asc
    |                                                     ^

Expected one of the following: 

'(', ')', '*' or '/' or '%', '+' or '-', ',', '.', '>=' or '<=' or '!=' or '=' or '>' or '<', '[', 'and' or 'or'

### Notes last touched today
Dataview: Error: 
-- PARSING FAILED --------------------------------------------------

> 1 | List FROM "" WHERE file.mday = date("<%tp.date.now("YYYY-MM-DD")%>") SORT file.mtime asc
    |                                                     ^

Expected one of the following: 

'(', ')', '*' or '/' or '%', '+' or '-', ',', '.', '>=' or '<=' or '!=' or '=' or '>' or '<', '[', 'and' or 'or'

@amine-a11
Copy link

amine-a11 commented Sep 23, 2024

@1artist use these instead :

List FROM "" WHERE file.cday = date("<%tp.date.now('YYYY-MM-DD')%>") SORT file.ctime asc
List FROM "" WHERE file.mday = date("<%tp.date.now('YYYY-MM-DD')%>") SORT file.mtime asc

@Lavender-Daydream
Copy link

Using those lines of code, I don't get an error, but I just get this, even after I make an edit to another note

Screenshot 2024-12-03 044918

@dannberg
Copy link
Author

@Lavender-Daydream Most likely the directory structure of your query is incorrect. Make sure you verify that you use the same structure in your vault as is in the Dataview table. My secret weapon is ChatGPT. You can feed it a table and tell it what to change and it usually spits out a working table.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment