SELECT  b.CreateDate, *
FROM         ConsolidatedData_DealSheet AS a INNER JOIN
                      Deals AS b ON a.DealNo = b.DealNo

2007-11-13 15:40:15.627 07110001    Atlantic
2007-11-13 16:27:13.783 07110002    Midwest
2007-11-13 17:18:47.783 07110003    Midwest
2007-11-16 14:06:27.917 07110004    Atlantic
2007-11-20 12:49:17.343 07110005    Midwest
2007-11-21 10:57:23.903 07110006    Midwest

SELECT  b.CreateDate, *
FROM         ConsolidatedData_DealSheet AS a INNER JOIN
                      Deals AS b ON a.DealNo = b.DealNo
WHERE
  b.CreateDate  BETWEEN
  CONVERT(datetime, '11/16/2017') AND  DATEADD(day,1,CONVERT(datetime,  '11/21/2019'))

select * from Deals where Createdate between   CONVERT(datetime, '11/16/2017') AND  DATEADD(day,1,CONVERT(datetime,  '11/23/2019'))

SELECT  b.CreateDate, *
    FROM         ConsolidatedData_DealSheet AS a INNER JOIN
                          Deals AS b ON a.DealNo = b.DealNo
    WHERE
      b.CreateDate  BETWEEN
      CONVERT(datetime, '11/16/2017') AND  DATEADD(day,1,CONVERT(datetime,  '11/21/2019'))