title: VB Date picker format confused when saving to sql
body: <p>I have been using date pickers for users to select a short date (UK format), the program grabs the datepicker.text and saves that as a string (I know :) bear with me) to an sql database. </p>
  
  <p>When I needed to do something I got the values, converted to dates and compared. No problem! </p>
  
  <p>I got to a problem area which was comparing the stored dates with date pickers on a form, in the actual query in the sqlcommand command text. it obviously wont compare a date with a string. </p>
  
  <p>so I went and changed my database to store the date field as a date not a string. </p>
  
  <p>Since then I have been having issues grabbing any dates, as the ones I save from the datepickers into the SQL database are for some reason turned into US Dates so when i extract them they are then backwards with the month and day. </p>
  
  <p>and if I save say 20/11/2015 it errors as it cant save the date as its too large on the month US style </p>
  
  <p>I extremely tempted to go back to storing dates as strings as that actually works, but would rather do it properly</p>
  
  <p>Does anyone have any suggestions or has done any workarounds for this issue.I would most like to hear them </p>
  
  <p>many thanks  </p>