title: Sql Update command VB.Net With Date
body: <p>I have an SQL update command that I can't get to work. i want it to update the fields where the date is equal to the current date. It works for my INSERT and SELECT statements. But I get a missing operator error when using it for my Delete statement below.</p>
  
  <pre><code>     Cmd.Connection = conn
       Cmd.CommandText = "UPDATE tbl_Expenditure SET E_Stock =" &amp; NewEStock &amp; "," &amp; "E_Total =" &amp; ETotal &amp; "WHERE [E_Date] = #" &amp; thisMonth &amp; "/" &amp; Day &amp; "/" &amp; thisYear &amp; "#;"
      Cmd.ExecuteNonQuery()
  </code></pre>
  
  <p>Ive tried searching this site as well as others and can't seem to find an answer.</p>
  
  <p>This is my error</p>
  
  <p>Syntax error (missing operator) in query expression '95WHERE [E_Date] = #4/1/2015#'. </p>
  
  <p>Thanks for any help</p>