command between

[Markoleo]

Dim cs As String = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source=c:\database.mdb;Jet OLEDB:database Password= 1"

Dim ad4 As New OleDb.OleDbDataAdapter("select * from table where date BETWEEN '" & CDate(TextBox1.Text) & "' and '" & CDate(TextBox2.Text) & "' ", cs)


"Data type mismatch in criteria expression!"

i don't no, what is problem with this.


Dim time As TimeSpan

TextBox1.Text = CDate(System.DateTime.Today)
TextBox2.Text = CDate(System.DateTime.Today + System.TimeSpan.FromDays(20))

 

[lingsn]

May be try this

Dim cs As String = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source=c:\database.mdb;Jet OLEDB:database Password= 1"

Dim ad4 As New OleDb.OleDbDataAdapter("select * from table where date BETWEEN #" & CDate(TextBox1.Text) & "# and #" & CDate(TextBox2.Text) & "# ", cs)

 

[Markoleo]

{"Syntax error in date in query expression 'Date BETWEEN #9.1.2007# and #29.1.2007#'."}

 

[lingsn]

You should use "/" instead of "." and the date format may be is "MM/dd/yyyy".

 

[Markoleo]

You should use "/" instead of "." and the date format may be is "MM/dd/yyyy".

dateformat in database is short date(19.6.2007)



select * from letovi where Date BETWEEN '/ & CDate(TextBox1.Text) & /' and '/ & CDate(TextBox2.Text) & /'



again

"Data type mismatch in criteria expression!"

 

[lingsn]

Can you try this out?

Dim ad4 As New OleDb.OleDbDataAdapter("select * from table where date BETWEEN #01/09/2007# and #01/29/2007#", cs)

The short date you mention is only for you to see the data when you use the database, not affected in the program.

 

[Markoleo]

Dim time As TimeSpan

TextBox1.Text = CDate(System.DateTime.Today)
TextBox2.Text = CDate(System.DateTime.Today + System.TimeSpan.FromDays(20))

but date is between textbox1 and textbox2,
and read data from database where date inside border.

 

[lingsn]

May be you have to do some formatting:

Dim time As TimeSpan

TextBox1.Text = Format(CDate(System.DateTime.Today), "MM/dd/yyyy")
TextBox2.Text = Format(CDate(System.DateTime.Today + System.TimeSpan.FromDays(20)), "MM/dd/yyyy")