calendar-week

[ttal7878]

Hi,

In my model, I'm using calendar  that displays, day, month, year and the number of the week.

I have a problem with the week dimension

The week between 31.12.2017 and 6.1.2018 is set as weeks53, Is it possible to change it to show week1?

I've included the model with the calendar I'm using,

I would appreciate any help

[YoussefBelloum]

Hi,

try this:

.

.

.

          if(Div( tempdate - WeekStart( WeekYearRefDate, 0, $(vCal_FD) ) + 7, 7 )=53,'1', Div( tempdate - WeekStart( WeekYearRefDate, 0, $(vCal_FD) ) + 7, 7 )) as WeekNumber,

.

.

.

[ttal7878]

Sorry for the late response,

It does not work.

When I the user selects Week - 1, the selected dates are 31-12-2017 till 13.1.2018

the result I want :

Week 53 - 31.12.2017

Week 1 - 01.01.2018 till 6.1.2018

Week 2 - 07.01.2018 till 13.01.2018

And so on.....

[Anil_Babu_Samineni]

Can you try this Redefining the Week Numbers

[ttal7878]

According to Redefining the Week Numbers, I built the Week dimension

[Anil_Babu_Samineni]

From there you can forecast the week based on Date field?

[sunny_talwar · Accepted solution]

I think you need to set vCal_RD  = 4, instead of 7

Set vCal_RD = 4; // Reference day = This day in Jan defines week one {1..7}

[ttal7878]

Thank you