sql problem with date

Printable View

Hi,

its a rookie question but my sql tag does not work
VB Code:
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

Apr 17th, 2002, 05:08 AM
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):

Code:

"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:

Code:

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

hope that helps
Apr 17th, 2002, 05:16 AM
Ecniv

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

Vince
Apr 17th, 2002, 05:49 AM
tr0n

the same :)

VB Code:

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

my code gifs the next problems

Apr 17th, 2002, 06:04 AM
Heribertt
sorry: i have yest press the wrong buttom
VB Code:
```
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