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
As mentioned in the thread I have the note
[[Project]] which includes the keyword
With query :
`=([[Project]].dueDate - date(today)).days`
I get result 77 (since today is 2022-06-14)
Which is as expected.
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.
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?
PS: I think that this is one thing and implementation of weekend days is second. Potentially very useful for work-related stuff.