I have tried changing week start to Sunday using this code: WeekStart(Datefield, 0, -1) as WeekStart and this works as expected. When I choose a particular week number, it displays dates starting from Sunday of that week until Saturday which is fine. But the problem is, when I choose the last week (say, week 53) in a particular year (say, 2015) I don't see all 7 dates, as few dates would belong to next year. I would like to include these dates also into previous week. How can this be achieved?
Attached in my example, When I choose, week 53 of 2015, would like to include 1st and 2nd Jan of 2016 too.
I have marked the correct answer. But I reloaded the app in my system today and it displays wrong dates again (1st and 2nd Jan of 2016 are not included as it was showing before). No idea what could be the issue.
