CommunityMember113484
Occasional Contributor

Time - week ending

Hi,

I have a module where teams are required to input weekly but at a specific schedule

e.g. week ending 7th, 15th, 23rd, and last day of each month.

Is it possible to configure this?
Thanks

8 REPLIES8
ChrisAHeathcote
Community Boss

@CommunityMember113484

If you model is using a weekly default calendar you can configure the format to be 'week ending.'

ChrisHeathcote_0-1623418205412.png

If your model is using a monthly default calendar it is not possible to use a time dimension to achieve this.

However, you could create a list and use this in your module.

You will then need to map this list back to a monthly time period using a systems module.

Chris
HeathcoteAndHerran.com
CommunityMember113484
Occasional Contributor

Hi Chris,

My model is dimensioned by weeks already. I've now changed to week ending, but I need it specifically for the dates mentioned each month: 7th, 15th, 23rd and last day of month - is this possible?

Thanks

ChrisAHeathcote
Community Boss

You can set the correct sequence of weeks by updating the 'end of fiscal year'

ChrisHeathcote_0-1623420173251.png

Chris
HeathcoteAndHerran.com
CommunityMember113484
Occasional Contributor

Sorry for not getting this - I'm not getting w/e 7th, 15th, 23rd and last day of month?

CommunityMember113484_0-1623420477406.png

ChrisAHeathcote
Community Boss

不可能创建一个日历的week ends land on the same day numbers each month as the length of each month is not equal.

How many weeks are you expecting to see in each month?

Are you using a 4-4-5 or other combination of weeks to build you model calendar?

Can you post a screenshot of your current time settings.

Chris
HeathcoteAndHerran.com
CommunityMember113484
Occasional Contributor

Yes using the 4-4-5. Current time settings below:

CommunityMember113484_0-1623421930005.png

ChrisAHeathcote
Community Boss

What you are asking for is not possible.

The closet I have managed results in the following;

ChrisHeathcote_0-1623423171356.png

Use the following settings;

ChrisHeathcote_1-1623423202375.png

The months simply do not follow the required pattern to generate what you are looking for.

Chris
HeathcoteAndHerran.com
CommunityMember113484
Occasional Contributor

Ah okay, thanks for your help. I did something similar in 2021 to get close.

Thanks again,