2 week selection in Calendar

[Anonymous]

I've added following line into the Calender:

week(PeriodDate) -1) & '-' & week(PeriodDate)                                          AS TwoWeeks,

When I look at the result in a table I see 1-2, 3-4, 5-6 etc. So far so good

But when using this result in a selection, it's only filtering the last week.
Selection week 34-35 only shows week 35
See image below

[Gysbert_Wassenaar · Accepted solution]

Your field TwoWeeks is only linked with one Week, e.g week 35. To fix this you could try something like:

2*(floor((1+week(PeriodDate))/2))-1 &'-'& 2*(floor((1+week(PeriodDate))/2)) as TwoWeek

[Anonymous]

It works!
Thanks.