The query below gives me the total accounts with the same submission date. But I need the total accounts with the same year only.
What needs to be changed in the query?
SubmissionDate is a DateTime datatype
SELECT count(account)as NumOfAccounts,SubmissionDate
Group By SubmissionDate HAVING count(account)> 0