Result inconsistency when comparing dates using file.name

[wenlzhang]

I have the following note content and queries within a note, 2022-06-25.md, for comparing dates.

[[2022-06-25]]

Test A:
dataview (this should be a code block)
table Status
where any(date(this.file.outlinks.file.name) - date(today) <= dur(7 days))

Test B:
`= date(this.file.outlinks.file.name) > date(today)`

Test C:
`= date(this.file.name) > date(today)`

For the first query, it was expected that the current file, 2022-06-25.md would be listed. However, the query gives no result.

Then I tested the second and third queries. It was expected that they give the same result, true. However, the second gives false (not as expected), while the third gives true (as expected).

After these tests, I would like to query notes that have date links, e.g. [[2021-06-22]], inside whose name is not older than certain days. So, I am wondering what I have missed that may have caused this?

[wenlzhang]

It seems that an operation like the following would be needed for comparing dates in such a case:
= date(this.file.outlinks[2].file.name) - date(today) <= dur(7 days).

Is it possible to support applying any to the index of outlinks?

[blacksmithgu]

Ah, this is because operations are not vectorized (array - value does not work). Adding support for that will probably make your original query work fine...

[wenlzhang]

Thanks for the reply. Can't wait for this to be supported! 😃