Filtering a view in SharePoint list based on a year
14,442
[Today]
returns the current date so you can use the following formula:
[Year] > YEAR([Today])-3
Author by
Tschareck
Updated on June 14, 2022Comments
-
Tschareck almost 2 years
I'm using SharePoint 2010.
I want to create new view for my list. The list contains a column called
Year
, which is a number and contains, as name suggests, year. Eg.:2012 2011 2010 2009
I would like create a view, where I would display only last 3 years. Under creating new view, I go to
Filter
, chooseShow items only when the following is true:
, pick columnYear
and... this is where I get lost.How to write a condition, that a number should be greater that current year minus 3? I tried
[Year]-3
but this obviously couldn't be so simple. Please help me write this condition.