Hi,
I have a date problem with a SQL statement.

example

Dim MyDate1 as date
Dim MyDate2 as date

MyDate1 = "09/12/99"
Mydate1 = Format(MyDate1, "DD/MM/YY")

MyDate2 = (MyDate1 + 3)
Mydate2 = Format(MyDate2, "DD/MM/YY")

Then I write an SQL (Select * from ... between MyDate1 and MyDate2)statement that selects a recordset between the 2 dates, but I always get a recordset that begins at 12/09/99
(12 september 1999).

Why does this happen ?

R@emdonck