Dataview & Periodic notes render different week numbers

[mayankgupta]

What I’m trying to do

I’m trying to see all the tasks done in a week. And for that I’m using query described here -

Tasks query, tasks completed in weekly, monthly, quarterly notes

With the information you give (for now) we can try an example for your weekly note. For monthly cases and others we don’t have info enough to define “where we have a valid date information - other than the creation date - to compare with the daily notes dates”. So, for weekly note I’ll take as example the title/name format “2022-W38”. # weekly ```dataview TASK WHERE file.day.weekyear = number(split(this.file.name, "W")[1]) WHERE completed WHERE contains(tags, "#keydaily") ``` Explaining: …

Issue I’m facing

Dataview plugin is returning Dec 11 note’s Week (=this.file.day.weekyear) as 49 and when I create Weekly note using #Periodicnotes, then it creates the week note as 2022-W51.

How can we fix this?

[mnvwvnm]

Dataview uses iso/luxon date formats… I guess Periodic notes plugin uses another one (locale?).
See this: Daily Note plugin -- week of year incorrect? - #6 by WhiteNoise

[mayankgupta]

Thanks a ton for sharing the link!

Seems like in order to solve this issue one has to change the Calendar plugin settings -

1. set the start of the week as Monday and
2. also change the local to en-gb.

[mnvwvnm]

Or, in some cases, using a calculation like ... = date(today).weekyear + 1