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 !
ww
ReplyDelete