Hi.. i have a calendar month from Jan to Dec (PFA) ... and i am using one button to select last 3 months of data ..for that using ACTION-->SELECT IN FIELD-->SEARCH STRING(='>='&MonthEnd(max({1} Day), -2)), but it is showing May, Jun, July data but i need to disply Apr,May and June data only ..i tried in many ways ..but not getting please any one can help me how to get this..
Here is a solution which may work for you. As far as I can see, you need to have a lower limit and an upper limit for the 3 month period e.g. 01/04/2013 - > 30/06/2013 to select a 3 month period. I havevn't used the select fields action before, but it seem quite tricky to get something like a logical AND when you working with dynamic expressions, but using the Toggle Select action seems to work. I've set this up to dynamically select the 3 previous months, relative to the month you're in.
