Between dates?
"fredg" wrote in message
...
On Sat, 22 May 2004 10:59:00 -0400, C & J Jones wrote:
Hello all,
When using the statement: Between [StartDate] And [EndDate], the
records
returned include those on the start date but no records are returned
from
the same month as the end date.
example: [StartDate] , 01.10.04
[EndDate], 05.22.04
First record returned is 01.01.04
Last record returned is 04.28.04
All records for May are not returned.
Any help would be appreciated.
What happens if you enter the dates in
1/1/2004
5/22/2004
format?
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
By BAD, that was embarrassing easy, both the"/" and "-" work. I picked up
the habit of using the dot long ago while working with a European supplier
and it has stuck who knew??
Thanks again.
Jim
|