Between dates?

  • Thread starter Thread starter C & J Jones
  • Start date Start date
C

C & J Jones

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.
 
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.
Click to expand...

What happens if you enter the dates in
1/1/2004
5/22/2004
format?
 
fredg said:
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.
Click to expand...

What happens if you enter the dates in
1/1/2004
5/22/2004
format?
Click to expand...

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
 
Back
Top