Hi!
I’m trying to set up the available days left on a project counter.
I in fact found a partial solution to my question this thread
Things I have tried
As mentioned in the thread I have the note [[Project]]
which includes the keyword dueDate:: 2022-08-31
.
With query :
`=([[Project]].dueDate - date(today)).days`
I get result 77 (since today is 2022-06-14)
Which is as expected.
What I’m trying to do
I’m trying to keep track of how many available days I have until the due date of the Project. Meaning I know that from 2022-06-20 to 2022-06-24 I won’t be able to put any work into my project which effectively cuts the due date by 5 days.
But if I change my due date to: dueDateCut:: 2022-08-26
and do:
`=([[Project]].dueDateCut - date(today)).days`
But when I get to next week e.g. 2022-06-27 my dueDateCut
should again be 2022-08-31.
What works:
I managed to put together a workaround:
In [[Project]] I’ve created keywords unavailableEvent1:: 5
for the number of unavailable days, and I’ve created a counter keyword
unavailableClounter:: `= [[Project]].unavailableEvent1 + [[Project]].unavailableEvent2 + ... `
which gives 5 so far. Then I manually set the dueDateCut:: 2022-08-26
and at the top of my daily note I have:
Available days: `=([[Project]].dueDateCut - date(today)).days`, total days `=([[Project]].dueDate - date(today)).days`
And the idea is to delete unavailableEvent1
after it happens and move the dueDateCut
manually. On the one hand, the manual solution might be good to keep me aware. On the other I’m lazy…so… you know.
Any ideas for a more elegant solution / workaround? Or is it too much for dataview and I need dataviewjs or something completely different?
Thanks!
PS: I think that this is one thing and implementation of weekend days is second. Potentially very useful for work-related stuff.