title: VB.net Date Format Gridview dd/mm/yyyy
body: <p>Hello
  I'm trying to update a ms access database. I've got a gridview with a date that i use:</p>
  
  <pre><code>Dim tBox As TextBox = CType(gridStaff.Rows(e.RowIndex).FindControl("sDate"), TextBox)
  </code></pre>
  
  <p>I then want to take the value from this textbox and assign it to a date variable.</p>
  
  <pre><code>Dim test As Date = CDate(tBox.Text)
  </code></pre>
  
  <p>The problem I have is that now when I put test variable into my sql update query it stores the date in this format. mm/dd/yyyy instead of the dd/mm/yyyy format I want.</p>
  
  <p>Ive tried different ways to format it I read online but to no success yet. Any advice would be great!</p>
  
  <p>Thanks</p>