1 Reply Latest reply on Nov 19, 2018 11:54 AM by Deepak Rai

    Filter a SUM(IF DATEFIFF...) by certain year for reference line

    Garrett Dube

      Hi all,

       

      In order to count submissions, I'm using a datediff calculation and then summing that up. I want to be able to filter it by a given year, such as a where clause but am not sure how. For example, Account Create Date and Program First Sales Date where year = 2017. Any ideas would be helpful!

       

       

      Thank you,

      G