I am trying to count records only if the referral month is 1 and the referral_start date iis within the current year.
I have name fields as follows referral month - referral
referral_start_date - start_date
I am getting a syntax error when I try to add the year comparison. This is my statement . Can someone tell me what it should be?