5 Replies Latest reply: Apr 19, 2011 10:23 AM by Ralf Becher RSS

    Problem comparing dates after Max and Aggr functions


      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.