Thank you for your response
But i am not showing the Date field itself in the table hence the above formula won't show any data. I had mentiond that in the question itself
Can you use the below calculation which will help you to have values even if you are moving ahead to a new year
DATEDIFF('month',[DATE],[today])<=3 and DATEDIFF('month',[DATE],[today])>=1
DATE = Database filed.
Use this calculation in the filter which only fetches the last 3 months.
thanks for the response
I suspect that this formula won't work when I run this report in JAN,2017. I ran the calculated field provided by you with the [today] calc. field which ahs Jan,2017 date and it didn't work. this is the same reason why I had taken the today as a calc. field