尝试 -

 选择 * 来自 表 其中 from_date> = '  2015-10-01'  AND  to_date< = '  2015-10-30' 

尝试

 选择 LR.Lunch _BookingID，
 E.EMP_NAME  as  RequestedByName，
 LR.From_Date，
 LR.To_Date，
 LR.Type_of_Requirement， 
 P.PRJ_NAME  as  Project_Name 
 From  LUNCH_REQUEST  as  LR  LEFT   OUTER  加入 
 PMS_TEST.Common.EMPLOYEE  as  E  ON  E.EMP_NO = LR。 Requested_By  INNER   JOIN  
 APPROVER_STATUS  as  APS  ON  APS.Status_ID = LR.Status_ID  INNER  加入 
 PMS_TEST.Common.PROJECT  as  P  ON  P.PRJ_ID = LR。 Project_ID 
其中 GETDATE（）  '  2015-10-01'  AND  ' 二零一五年十月三十日' 跨度> 

Hi,

I have table in which i have a columns From_date, To_date

i want to get the records between passing Dates as Input

i wrote my query as written below.

Select * from Table Where from_date >= '10/01/2015' AND to_date <= '10/30/2015'

not able get the records based on passed dates

Try-

Select * from Table Where from_date >= '2015-10-01' AND to_date <= '2015-10-30'

Try

Select LR.Lunch_BookingID, 
E.EMP_NAME as RequestedByName, 
LR.From_Date, 
LR.To_Date, 
LR.Type_of_Requirement, 
P.PRJ_NAME as Project_Name
From LUNCH_REQUEST as LR LEFT OUTER JOIN 
PMS_TEST.Common.EMPLOYEE as E ON E.EMP_NO = LR.Requested_By INNER JOIN 
APPROVER_STATUS as APS ON APS.Status_ID = LR.Status_ID INNER JOIN 
PMS_TEST.Common.PROJECT as P ON P.PRJ_ID = LR.Project_ID 
Where GETDATE() between '2015-10-01' AND '2015-10-30'