Forum Discussion
Re: Problems with static values in sharepoint list - possible workaround with JSON??
Hello @michalkornet
Thanks for your responses. I belive this worked for me as I implemented it last week, checked the view this week and the change from last week is gone as I wanted. I thereford wanted to ask you the same for the year. I filter using the year in a similar way and worried about whether it wont update, even though its only every 365 days this would pose problem. Im worried if this method will also not refresh automatically, can you tell me please?
1 Reply
Hi MatildaB1280, in this case, we can use a similar approach as in the 'week' example. The 'Change-Year' column is fine and can be used in the view filters. The easiest way would be to simply enter '2024' in the filter input for this year, like this.
I also saw some examples where we can create two calculated columns: one for the start of the year from a date (to get January 1st, 2024) and another for the end of the year (to get December 31st 2024). Then, we can filter items in the view where Today is greater than the start date and less than the end date.
