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!
Please attach a workbook.