Date/Time field

[lothos12345]

I have written a VB.NET program that interfaces with a Microsoft Access database. Now my problem lies when I try to execute an SQL statement using a date/time field in the where clause of the SQL statement. It keeps giving me the error of invalid SQL statement. Below is a copy of the SQL statement I am using any help would be greatly appreciated.

 

Dim datefirst As Date

Dim datelast As Date

Dim StrWhere As String

Dim appAccess As New Access.Application()

 

datefirst = CDate(flddate.Text)

datelast = CDate(flddatelast.Text)

StrWhere = "SELECT * FROM Daily WHERE Daily.date >= #datefirst# AND Daily.date <= #datelast#"

[Robby]

try this...

StrWhere = "SELECT * FROM Daily WHERE Daily.date >= #" & datefirst & "# AND Daily.date <= #" & datelast & "#"

[lothos12345]

Thank You

 

Thank you very much that did the it.