sql problem with date

[cusmar]

Hi,

its a rookie question but my sql tag does not work

sqltoevoegen = "SELECT * FROM toevoegen WHERE datum BETWEEN " & Bdatum & " AND " & Edatum & " "
 
explaination:
 
toevoegen = tabel name
datum = date/time field
bdatum = dim bdatum as date
edatum = dim edatum as date
 
bdatum = txtbdatum.text
edatum = txtedatum.text

my problem is that he wil not look in the field. I want that I can search between two date's