How to change the date period of saved view automaticaly when change the Start Date of Time

Jialiang
New Contributor

How to change the date period of saved view automaticaly when change the Start Date of Time

I have set the Start Date like the following:

Jialiang_0-1621929057561.png

And make a module with all days of April(2021/3/29~2021/5/9) as the following:

Jialiang_1-1621929104294.png

Now,I want to get the data in weekly(like, the first week),so I saved a new view by showing the selected rows of '29 Mar 21' to 'w/c 29 Mar 21',refer to the following:

Jialiang_2-1621929407957.png

 

 

The Question Is:

When I change the Start Date of Time,I want it can change the date period automatically,HOW CAN I DO IT?

 

Operation:

Jialiang_3-1621929607699.png

What I expected:

Jialiang_4-1621929692308.png

 

Thanks

2 REPLIES 2
Misbah
Moderator

Re: How to change the date period of saved view automaticaly when change the Start Date of Time

@Jialiang 

 

Create a SYS TIME module at day level and write the formula

 

CURRENTPERIODSTART() <= START() AND CURRENTPERIODEND() >= END(). Use this as a filter in your modules.

Misbah_0-1621933599706.png

Misbah

vinayvm
Certified Master Anaplanner

Re: How to change the date period of saved view automaticaly when change the Start Date of Time

Hi @Jialiang ,

 

While @Misbah has already provided you the solution, I would like to add that you need to update 'Current Period' in time settings to make this work.

I noticed that you are changing the 'Start Date', which could result in loss of data pertaining to previous time. You can instead keep the start date constant for that year, and just update the current period for the time settings filter to work.

 

Regards,

vinayvm