3 Replies Latest reply: Nov 1, 2015 11:20 PM by Kumar Pramod RSS

    last year count

      Hi all,


      I am trying to get the last year count using below expression.

      Last year:

      count({$<CanonicalDate = {">=$(=Yearstart(Max(CanonicalDate),-1)) <= $(=YearEnd(Max(CanonicalDate),-1))"},

      DateType= {'invitation'}>} invitation_id)


      Present Year:

      count({$<CanonicalDate = {">=$(=Yearstart(Max(CanonicalDate)))  <= $(=Date(Max(CanonicalDate)))"},

      DateType= {'invitation'}>} invitation_id) 


      With last year expression i am getting the count till today.


      Please check and help.