3 Replies Latest reply: Jan 6, 2017 4:43 AM by Goutham V RSS

    Getting counts of last year,,,

    Goutham V

      Hello all,,,

       

      I'm unable to get the count value(invitation_id) of the last year's invitation.

      Script:

      Load `invitation_id`,

      `date_created`;

      SQL SELECT

      `date_created`,

            `invitation_id`

            FROM invitation;

       

      Expression:

      count({$<date_created={$(=Year(date_created) - 1)}>}invitation_id)

       

       

      Thanks in advance