Is file.mday impacted by Obsidian sync?

[sofie-bird]

I have two tables in my daily note: one shows me what notes I created that day, and the other shows me what existing notes I updated. Except lately, the "Updated" table just shows every note I created the previous day, even if I didn't update it.

Table code:

TABLE length(file.inlinks) AS "Backlinks"
WHERE 
     noteType = "permanent" AND 
	 file.mday = date("2022-01-08") AND
	 file.cday < date("2022-01-08")

I expect that to show me anything that has been updated on the 8th that was created before the 8th. That's what it used to do when I first build the table. But now it just shows me everything I created on the 7th, even if that file has not been touched since.

I use Obsidian sync, and I switch between quite a few devices (some mobile, one Win10 desktop), so sometimes files are downloaded to a new device the following day. Would a device downloading a file during sync update the file.mday?

[blacksmithgu]

Hmm, I think it may indeed affect file.mday - that value is pulled directly from the filesystem, which is updated on Obsidian Sync. Making it accurately reflect the last meaningful change (across devices) would require some extra book-keeping that Dataview currently does not do.

[sofie-bird]

Thank you for the prompt answer! I'll have to think about how to create my own book-keeping for that.