Hi
I have a block which contains the result of a query - a date. But this block displays the date as a number.
Now I want to create a query that uses that block (it’s the parent block) as an input, and compares the block’s date against another date. But the date is a number…
How can I convert that number to a date for the query?
Sure
So I started setting a property ‘futuremeeting’ with value as a name of a person
I have a template for a 1v1 meeting with that person
Inside the template I run a query getting all the blocks which has that property and that person’s name.
The problem is, I’m getting all the blocks, even the old ones, i.e. even the ones older than the last meeting with him.
So I’m trying to run a query that will get all the blocks with the property, where the block’s date is newer than the date in which the last 1v1 meeting took place.
I couldn’t find a way to do that in 1 query, so I divided it:
Running a query that gets the date of the last 1v1 meeting
as a child block, and using the parent block (with the first query’s result as input), trying to get all the relevant blocks which are newer than the last 1v1 meeting date (= the first query’s result)
Wow. Amazing, thank you!!
I spent so much time trying to get this to work.
Do you have a guide / doc reference for advanced queries? All the searches I made and I’ve never seen the ‘join’ parts
Is it possible to use this to calculate a streak?
In the journal I would have blocks with a page link to wandelen.
Would be nice to see how many days my current streak of walking every day is.
My initial idea was to get where the streak starts and then count the number of days until yesterday.
However a double (not ) doesn’t work.
I checked, I have 864 journal pages, of which 860 have a file
But! Setting that lower limit did the trick.
It now returns fast enough. I didn’t measure, but it is near instant instead of loading for a number of seconds.
Thanks a bunch! (sorry for being terribly slow in responding)