Help required in Set analysis

[#1]

Hi Folks,

I am trying to do the below set analysis. Can you see if you can help me out.

Here is the main expression

=MaxString( {< Title_Cat={'PMD'},Source = {'Interactions'},Date={"*********"}>} EmployeeName)

In place of *********, I have to add the below expression.

Max( {< Title_Cat={'PMD'},Source = {'Interactions'},Date={"<=$(vCurrentDate)"}>} Date)

How can I do that?

Thanks.

[MK_QSL]

Create a variable

vVar1 = Max( {< Title_Cat={'PMD'},Source = {'Interactions'},Date={"<=$(vCurrentDate)"}>} Date)

Now use

=MaxString( {< Title_Cat={'PMD'},Source = {'Interactions'},Date={'$(vVar1)'}>} EmployeeName)

or

=MaxString( {< Title_Cat={'PMD'},Source = {'Interactions'},Date={'$(=vVar1)'}>} EmployeeName)

[#3]

Hi Manish,

This doesn't work.

I doubt this is because vCurrentDate is again includes another set expression. Listing here all the expressions.

Is max function inside another max function will work in set anaylsis?

Final expression =MaxString( {< Title_Cat={'PMD'},Source = {'Interactions'},Date={'$(vVar1)'}>} EmployeeName)

vVar1 = Max( {< Title_Cat={'PMD'},Source = {'Interactions'},Date={"<=$(vCurrentDate)"}>} Date)

vCurrentDate    =  max(  { 1 < Date = {'<=$(vToday)'} >}Date)

vDate =  =Date(Today(),'MM/DD/YYYY')