You'll possibly also need to include time fields 00:00:00 and 23:59:59 in your beginning and end dates respectively. See how you go without, but I think Access always stores a time regardless of how you format the field. Hopefully the time part will be zero in the database, but you never can be sure.
BTW, can you be sure that the database engine will handle the dates in mm/dd/yyyy format? I always give SQL my dates in yyyy/mm/dd format to make absolutely sure there's no ambiguity. (Here, we use dd/mm/yyyy for normal date formatting, of course.) Dave S ----- Original Message ----- From: "Dian D. Chapman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, December 11, 2004 8:04 PM Subject: RE: [ASP] Help w/date mismatch? > > HA! Thanks...I didn't know that and was just going with the old SQL resource > book...I'll give it a shot! > > > Dian ~ > > > -----Original Message----- > From: Shawn K. Hall [mailto:[EMAIL PROTECTED] > Sent: Saturday, December 11, 2004 2:11 AM > To: [EMAIL PROTECTED] > Subject: RE: [ASP] Help w/date mismatch? > > > Hi Dian, > > > <sigh> I have everything in this query from hell working now > EXCEPT > > the last item...the dates. > > Dates in Access are wrapped with ##, not '' or "". > > Regards, > > Shawn K. Hall > http://ReliableAnswers.com/ --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.806 / Virus Database: 548 - Release Date: 5/12/2004 ------------------------ Yahoo! Groups Sponsor --------------------~--> $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
