V
Vayse
Hi
In an mdb, if I wanted to report by dates, I would do the following
stCriteria = "BETWEEN #" & Amer_Date(me.txtStartDate) & "# AND #" &
Amer_Date(me.txtFinishDate) & "#"
Amer_Date is just a function that changes the date to an American format.
This doesn't work in an ADP. I've tried using ' instead of #, but the date
range seems incorrect. The lower date works fine, but items on the
FinishDate won't appear.
For example, if I do a November test BETWEEN 10/11/06 and 13/11/06, the
13/11/06 stuff won't appear. If I set the upper date to the 14th, the 13th
data appears.
Does BETWEEN work different in SQL? Or is there something else I'm doing
wrong?
Thanks
Vayse
In an mdb, if I wanted to report by dates, I would do the following
stCriteria = "BETWEEN #" & Amer_Date(me.txtStartDate) & "# AND #" &
Amer_Date(me.txtFinishDate) & "#"
Amer_Date is just a function that changes the date to an American format.
This doesn't work in an ADP. I've tried using ' instead of #, but the date
range seems incorrect. The lower date works fine, but items on the
FinishDate won't appear.
For example, if I do a November test BETWEEN 10/11/06 and 13/11/06, the
13/11/06 stuff won't appear. If I set the upper date to the 14th, the 13th
data appears.
Does BETWEEN work different in SQL? Or is there something else I'm doing
wrong?
Thanks
Vayse