8 Replies Latest reply: Nov 20, 2012 7:42 AM by Arya v RSS

    expression based on a Date Field

    ahnet ceylan

      Hello ,

      My below expression is based on today -30

      but I want to based it on my dimension  =date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY')

      İn shortly my dimension - 30 all ı want

      =Count({<ISTEK_ACISTARIHI2 = {"<=$(=Timestamp(Today() - 30, 'DD.MM.YYYY hh:mm:ss'))"},ISTEK_DURUM={'Açik'}>} ISTEK_ACISTARIHI2)