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

    last year count

    Kumar Pramod

      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.

       

      Regards,

      pramod