accessing dates in ms access with visual basic

i have troubles in accessing dates in ms access with visual basic

the database is contains announcements and it has begindate(SHORTDATE) and enddate(SHORTDATE).

the code

adodcannounce.recordsource="select * from tblannounce where begindate <=' " + date + " ' and enddate >= ' " + date + " ' "

it has an error of TYPE MISMATCH
but when i access the dates individually and compare it with vb date, it has no error.

Newbie Poster

1 post since Jan 2009

Reputation Points: 10

Solved Threads: 0

This article has been dead for over three months