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

[tr0n]

first of all, are you using Access or SQL Server? secondly, what error are you getting? one thing i can see is that you gotta put single quotes around the dates (that's if you're using SQL Server, use a # if it's Access):

"SELECT * FROM toevoegen WHERE datum BETWEEN '" & Bdatum & "' AND '" & Edatum & "'"

otherwise, it's cos you're using SQL Server, and it doesn't like non-US dates by default, so you'd have to do this:

"SET DATEFORMAT DMY SELECT * FROM toevoegen WHERE datum BETWEEN '" & Bdatum & "' AND '" & Edatum & "'"

hope that helps

[Ecniv]

Tron :
Sql server uses single quotes for dates ??
What does it use from strings ?

Vince

[tr0n]

the same

[Heribertt]

sqltoevoegen = "SELECT * FROM toevoegen WHERE datum BETWEEN #" & Bdatum & "# AND #" & Edatum & "# "

my code gifs the next problems

[Heribertt]

sorry: i have yest press the wrong buttom

sqltoevoegen = "SELECT * FROM toevoegen WHERE datum BETWEEN #" & Bdatum & "# AND #" & Edatum & "# "

my code gifs the next problems

when i select by days smaller then 10 it fails

a solution would by to set the date american but i havend thry this.

when you have got the wright solution please tel me now.

thanks.
Heribertt