SQL between 2 dates not returning correct results
<p>I am using the query below and I would like to get the rows where "[Last Update Date]" is in either 2015 or 2016.</p>

<pre><code>SELECT [NPI]
      ,[Entity Type Code]
      ,[Replacement NPI]
      ,[Employer Identification Number (EIN)]
      ,[Provider Organization Name (Legal Business Name)]
      ,[Provider Last Name (Legal Name)]
      ,[Provider First Name]
      ,[Provider Middle Name]
      ,[Provider Name Prefix Text]
      ,[Provider Name Suffix Text]
      ,[Provider Credential Text]
      ,[Provider Enumeration Date]
      ,[Last Update Date]
      ,[Healthcare Provider Taxonomy Code_1]

  FROM [Database].[dbo].[NPIInfo]
  WHERE[Healthcare Provider Taxonomy Code_1] in ('122300000X', '1223G0001X','1223P0221X','1223P0700X')
  AND ([Last Update Date] BETWEEN '2015/01/01' AND '2016/12/31' )
  order by [Last Update Date]
</code></pre>

<p>I don't receive any results when I run the code above. But if I run it with this "AND" statement I get results:</p>

<pre><code>AND [Last Update Date] like '%2015%' or [Last Update Date] like '%2016%' 
</code></pre>

<p>This result gives me 500,000 + rows.</p>

<p>If I run it this way per year I get way less results:</p>

<pre><code>AND [Last Update Date] like '%2015%'
</code></pre>

<p>Any idea what I am doing wrong here? The last 2 And statements are giving me different results TIA</p>