I am trying to take a date field and add 3, 6, 9 months and then drop the year.

I cannot figure out how to do this in Yellow Fin. I am using the following SQL:

Select Clients.client_id As clientid, Clients.first_name As ClientFN,
Clients.last_name As Cient_LN, Clients.date12, Clients.client_status,
Clients.case_manager_emp_id, EmployeesView.first_name, EmployeesView.last_name,
dateadd(month,3,Clients.date12) AS f_qtr_rev,
dateadd(month,6,Clients.date12) AS s_qtr_rev,
dateadd(month,9,Clients.date12) AS t_qtr_rev
From Clients Left Outer Join
EmployeesView On Clients.case_manager_emp_id = EmployeesView.emp_id
Where Clients.client_status = 'Active' order by case_manager_emp_id


The output is correct but I cannot figure out how to format the new fields (f_qtr_rev, s_qtr_rev,t_qtr_rev) so the year will be dropped.

I would really appreciate any help with this.
Thank You.