If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|