Between dates?

[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.

 

[fredg]

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?

 

[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.

What happens if you enter the dates in
1/1/2004
5/22/2004
format?

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