Display Recent Month Red Programs

[fanninam]

I'm currently using the following to display a count of recent month Red Programs:

=count(

{<

[MonthYear2] = {'$(=max(MonthYear2))'}

>}

(Red)

)

I want to display a list of the recent month Red Programs.  What would the correct syntax be to display a list of the recent month Red Programs?

[sunny_talwar]

Display the list where? In a chart or list box object or somewhere else?

[fanninam]

Text Object would work.  I'm just having a hard time with the syntax.

[vishsaggi · Accepted solution]

You want count() or list of values to be displayed? And what is the format of your MonthYear2 field? It should have the same format in set analysis may be like below?:

=count({< [MonthYear2] = {"$(=Date(max(MonthYear2), 'MMMYYYY'))" } >} Red)

if you want to show the list of values in Red field for that max monthyear2 in text object may be use Concat() function.

= Concat({< [MonthYear2] = {"$(=Date(max(MonthYear2), 'MMMYYYY'))" } >} Red, Chr(13))