How to filter data

[#1]

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  to get this..

Regards,

Sh.

[swuehl]

Maybe like this?

='>='&MonthEnd(max({1} Day), -3)&'<'&Monthend(max({1} Day))

[Anonymous]

try with this...

='('& month(MonthEnd(max({1} OrderDate), -1)) & '|' & month(MonthEnd(max({1} OrderDate), -2))& '|' & month(MonthEnd(max({1} OrderDate), -3))& ')'

[Anonymous]

='('& month(MonthEnd(max({1} Day), -1)) & '|' & month(MonthEnd(max({1} Day), -2))& '|' & month(MonthEnd(max({1} Day), -3))& ')'

[#5]

Hi

Thanks to All for the reply ...Itried those conditions but are not helpful...please suggest some more conditions..

Regards,

Sh.

[#6]

Hi

Thanks to All for the reply ...I tried those conditions but are not helpful...please suggest some more conditions..

Regards,

Sh.

[#7]

Hi

Thanks to All for the reply ...I tried those conditions but are not helpful...please suggest some more conditions..

Regards,

Sh.