set analysis with wildmatch

[polisetti]

Hi,

I have a set analysis where i have to match an id. The expression is supposed to be like this:

max({<source=wilmatch(source,'*R*'>} date)

basically I want the max date with source having the letter R.

Please give the syntax for this. Please donot suggest using IF. Have other complications too.

Regards

[kaushiknsolanki]

HI,

     Try this.

     Max({<Source = {"*R*"}>}Date)

Regards,

Kaushik Solanki

[MK_QSL]

=Date(Max({<source = {"*R*"}>}date))