Return Anniversary Dates of staff

Return Anniversary Dates of staff

I am trying to query a staffing table I have set for scheduled imports into Zoho. My goal is to query all of the employees that have an anniversary in the current month. Below is the query I would write, but it looks like Zoho does not allow for GETDATE function. Any suggestions? 


SELECT
"Department",
    "EmployeeID",
    "FirstNameLastName",
    "LastNameFirstName",
    "MGR_FirstLast",
    "MGR_LastFirst",
    "StartDate",
    "status",
    "TermDate",
    "wasp_emp_key"
WHERE "StartDate">=DATEADD(mm,DATEDIFF(mm,0,GETDATE())-12,0)
 AND
 "StartDate"< DATEADD(mm,DATEDIFF(mm,0,GETDATE())-11,0)