The number of modified notes also includes the number of created files I would like to display the number of modified notes, but without the number of new notes of that day.
The result for the above line is for example: New: 13 and Modified: 63. I would like the modified number to show 50 (63 -/- 13).
But this does not solve my problem, because the result is “0”, which i don’t understand.
When I remove the “!” before the second part of, I get the result of 12. I think this is the result of all the new notes, without the daily-note of that day. I have searched this forum and more sites for better understanding off the code en tried multiple variations, but I couldn’t get it right.
It looks like that’s returning 0 because t.file.cday is a truthy value, which means !t.file.cday is coerced to false. There will be no documents where false == dv.current().file.day.ts, so length is 0.
I believe a slight modification to your code will give you the number of files that were modified today but created on a previous day (though I just lifted your code and haven’t tested it in Obsidian to confirm):
WHERE file.cday = date("2023-02-03")
SORT file.ctime DESC
WHERE file.mday = date("2023-02-03")
WHERE file.cday != date("2023-02-03")
SORT file.mtime DESC
I use the outcome as an part of the header of the callout.
With the plugin “Obsidian columns” I created 2 columns with each a dataview-query. The numbers in the header are the same amount as the number of items on the list.