format time error in Set Analysis

[#1]

Hi,

I'm trying to get the maximum value on the date using Set Analysis.

first y created a variable:

Date(MAX(Date(FECHA_PL)),'DD/MM/YYYY')

the result is OK!

Then I use this variable in Set Analysis but it returns Error

---------------

it should work like this:

[sunny_talwar]

How about this:

=Avg({<FECHA_PL = {'$(=Text(MaxFechaPL))'}>} ValorIndicator)

[swuehl]

Try

=Avg( {<FECHA_PL = {'$(MaxFechaPL)'}>} ValorIndicador)

edit: Assuming your variable is defined with a leading equal sign.

Or just use

=Avg( {<FECHA_PL = {'$(=Date(MAX(Date(FECHA_PL)),'DD/MM/YYYY'))'}>} ValorIndicador)

Dates in Set Analysis

The Little Equals Sign

The Magic of Dollar Expansions

The Magic of Variables

[vishsaggi]

May be an opening bracket after max like = Avg( {<FECHA_PL = {'$(Max(FechaPL))'}>} ValorIndicador)

Is there a fieldname MaxFechaPL, i doubt you missed a bracket here ? Correct me...

Thanks,

V.

[vishsaggi]

Sorry Is MaxFechaPL is your variable name ? If Yes, follow what sunny and swuhel suggested.

[#6]

it doesn´t work 😕

[#7]

I tried everything and what worked for me was this

= AVG ({<FECHA_PL = {$ (= Chr (39) & Max (date (FECHA_PL, 'DD / MM / YYYY')) & Chr (39))}>} ValorIndicador)

[#8 · Accepted solution]

I tried everything and what worked for me was this

= AVG ({<FECHA_PL = {$ (= Chr (39) & Max (date (FECHA_PL, 'DD / MM / YYYY')) & Chr (39))}>} ValorIndicador)