Limited selections from a list box

[hobanwashburne]

Can someone provide an expression that would limit the display of a list box to only those customers who have purchased an item in the previous 6 months?

[MayilVahanan]

Hi

Try like this

This may be work

=If(Aggr(Count({<DateField = {">= Date(MonthStart(Max(DateField),-6))<=Date(MonthEnd(Max(DateField),-0))"}>}Item),Customers) > 0, Customers)

Note:

Below expression worked for me, =If(Aggr(Sum(Sales),Monthyear) <= 32000, Monthyear) in listbox.

[srchilukoori]

IF(Count({1<Date = {">=$(=date(monthstart(today(), -6), 'MM/DD/YYYY'))<$(=date(monthstart(today()), 'MM/DD/YYYY'))"}>} Items) > 0, -1, 0)

Replace the Date & Items in the above expression and use it for the show/hide condition.