Get date with some criteria in SQL server

Question

What I want is the EmployeeName from the emp_mst table with some condition which is given below:-

1. All EmployeeName for last 7 months from the current date and also less 15 days.

from the below query I am getting the result for the last month, but I want this for the last 6 months

select DATEADD(month, -1, GETDATE()- 15)

I am using sql server 2008

UPDATED PROCEDURE

SELECT * FROM (SELECT CASE 
                 WHEN (SELECT Isnull(Sum(total_day), 0) 
                       FROM   xxacl_erp_ab_pl_count_view 
                       WHERE  emp_card_no = em.emp_card_no) > 7 THEN 
                 'DOC Exteded By 1 month. Reason:- Taken leave=' 
                 + CONVERT(VARCHAR, (SELECT Sum(total_day) FROM 
                 xxacl_erp_ab_pl_count_view 
                 WHERE emp_card_no = em.emp_card_no)) 
                 + 
' which is > 7. Actual DOC=' 
          + CONVERT(VARCHAR, Dateadd(mm, em.probation_period, em.date_of_joining), 103) 
          + '' 
          ELSE 'N/A' 
        END Remark, 
        em.* 
 FROM   emp_mst em 
        LEFT JOIN company_mst comp 
               ON em.comp_mkey = comp.mkey 
                  AND comp.fa_year = 2008 
                  AND company_name NOT LIKE '%HELIK%' 
 WHERE  em.status IN ( 'A' ) --and em.emp_type='E' 
        AND em.emp_card_no != 9999 
        AND em.resig_date IS NULL 
        AND CONVERT(DATETIME, em.date_of_joining, 103) >= 
            CONVERT(DATETIME, 
            Dateadd(m, -6, Getdate()), 103) 
        AND em.emp_card_no NOT IN (SELECT emp_card_no 
                                   FROM   p_emp_confirmation_hdr 
                                   WHERE  delete_flag = 'N' 
                                          AND hr_flag = 'Y')) pp 
WHERE  remark = 'N/A' 

Answer 1

Casting to date to avoid calculating with timestamps

WHERE
  yourdate >= dateadd(m, -6, datediff(d, 15, getdate())) and 
  yourdate <  dateadd(d, -15, datediff(d, 0, getdate()))

Changed answer to adjust for you using sqlserver 2005 or older

Added 15 days extra to the interval

Answer 2

SELECT [emp_name] 
FROM [TABLE] 
WHERE [DateColumn] BETWEEN DATEADD(MONTH, -6, CAST(GETDATE() AS DATE)) 
    AND DATEADD(DAY, -15, CAST(GETDATE() AS DATE))

This will show you employees who were added between six months ago and 15 days ago, for example, running that today would give you employees from the range 2014-12-24 and 2015-06-09.

EDIT: For SQL Server 2005 and earlier:

SELECT [emp_name] 
FROM [TABLE] 
WHERE [DateColumn] BETWEEN DATEADD(MONTH, -6, cast(convert(char(11), getdate(), 113) as datetime)) 
    AND DATEADD(DAY, -15, cast(convert(char(11), getdate(), 113) as datetime))