Wednesday 28 November 2012

SharePoint View to automatically show list data only the current month?


Create a CC "NextMonth" that adds one month to your date =DATE(YEAR(Modified),MONTH(Modified)+1,"1")
create a view "ThisMonth" with this filter
"NextMonth" is greater than [Today]
this will always return the current month. can also be allpied to Year, to return current year
Create a CC "NextYear" that adds one year to your date =DATE(YEAR(Modified)+1,MONTH(Modified),"1")
create a view "ThisYear" with this filter
"NextYear" is greater than [Today]

If you want to show list data for last 2 months, then you have to just modify the formula as below:
 =DATE(YEAR(Modified),MONTH(Modified)+2,"1")

Enjoy !

1 comment: