I am creating a small desktop application with connection to a Access Database.
I created the database in MS Access 2010.
I have a table BSKT_GAME with a key field (Game_date) with Date/Time. What I am trying to do is a SELECT to that table (in Visual Basic 2012) to retrieve records where the field Game_date is greater or equal to 11 January 2013.
This date is stored in a DateTimePicker Control.
First, to see the SQL statement, I created a Query in Ms Access, and it is as follows:
SELECT * FROM BSKT_GAME WHERE (((BSKT_GAME.Game_Date)>=#1/11/2013#));
and in MsAccess this works fine, the records shown are the correct ones.
My problem is when I put the code into VB2012:
Dim Sql as string
Dim dsGrid as new Dataset
Dim daGrid as new OleDb.OleDBDataAdapter
sql = "SELECT * FROM BSKT_GAME WHERE BSKT_GAME.Game_date >=#" & datetimepicker.value & "#;"
daGrid = New OleDb.OleDbDataAdapter(sql, Connection)
and in the MsgBox the value is 0, which is not correct.
One thing i noticed in Debug is that the datetimepicker.value appears as #1/11/2013# when i add a whatch, but when passed to the SQL it is transformed into #11-01-2013# .
Can anyone help me please ?