In short, what I’d like to do is set up a dataview table that shows how many days I’ve been working on a project (days from file creation date to the present day). But also, to only have projects “in process” (not completed) populate the table. Or, if possible, have a separate column indicate whether a project is in process or completed and if changed to completed, stop adding any more days so I know how long it took to complete.
I have a central note where I like to track my present projects, tasks, etc. I presently use the following dataview code block to help keep track of work memos:
dataview
TABLE Stage, dateformat(file.mtime, "dd.MM.yyyy") AS "Last Modified"
FROM !"➕ Extras"
WHERE Stage = "🚧"
LIMIT 25
(I keep my templates in the “ Extras” folder, hence omitting any files from that folder.)
My template for writing articles and/or memos presently uses the following YAML metadata:
---
Stage: ⚙️|🚧|🏆
---
The gear indicates it’s in the early research phase, the construction post is for when I get to the drafting phase, and the trophy signifies completion.
I’m open to adding some more items to YAML such as:
Start_Date: <% tp.date.now("YYYY-MM-DD") %>
Completion_Date:
But if it’s possible to do what I’d like to do without changing my template I would much prefer that.
Thank you in advance for any help.