I have a year column in one of the SharePoint list.
I want to create a view to filter the items by current year.
How to do this?
I have tried a lot but it doesnt work.
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
You can use calculated columns to achieve that:
Have a year column called "Year".
Create a calculated column called "startOfYear" with the following formula to get the first day of this "Year":
Create a calculated column called "endOfYear" with the following formula the get the last day of this "Year":
You will get:
Create a view and configure the filter to only display items which the "Year" is current year.
For displaying items that the year is not equal to current year: