Problem comparing dates after Max and Aggr functions

[#1]

Hi,

i have a big mistake regarding following calculated dimension:

if(date(Aggr($(Max_), PRODUCT_CODE))<$(T2), date(Aggr($(Max_), PRODUCT_CODE),null())

with this Max_ = date(Max({$<RicevConsum.POST_DATE={'<=$(=$(T1))'},RicevConsum.TIPO={CONS,REC}>}RicevConsum.POST_DATE))

This expression works only with <'dd/mm/yyyy' in place of $(T2), i need to filter the aggr results using a date stored in variable, instead of date value ('18/10/2010').

Many thanks at all.

[rbecher]

Hi,

have you tried to quote variable T2?

...< '$(T2)'

- Ralf

[#3]

Yes Ralph, i've tried this <'$(T2)' but the filter has no effects, results contains all possible dates.

[rbecher]

Can you post an example app?

- Ralf

[#5]

Sorry Ralph, but i can't post data.

[rbecher]

You could load some demo data (inline?)...

- Ralf