-----Original Message----- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Friday, November 23, 2001 2:49 PM To: CF-Talk Subject: Re: Trouble with Dates
grrr.my posts aren't coming through...... use #CreateODBCDate(Form.Date)# instead of that annoying Access ###DateFormat()### crud then if you switch DB your code will just work ;-) Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Allaire Alliance Partner www.allaire.com ----- Original Message ----- From: "Mike Craig" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, November 23, 2001 11:36 AM Subject: RE: Trouble with Dates > right database differences...forgot access like the pound signs. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 23, 2001 2:45 PM > To: CF-Talk > Subject: RE: Trouble with Dates > > > I found it. I dug out a Access development book. > It looks like date in access have to be enclosed in #. > > So this seems to to the trick - > WHERE ((Course.CourseDate) Between ###form.StartDate### And > ###form.EndDate###); > > Thanks > > -----Original Message----- > From: Mike Craig [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 23, 2001 2:19 PM > To: CF-Talk > Subject: RE: Trouble with Dates > > > WHERE ((Course.CourseDate) Between '#DateFormat(form.StartDate,"m/d/yyyy")#' > And > '#DateFormat(form.EndDate,"m/d/yyyy")#)' > > note the single quotes around the date fields. I thought you had to have > those. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 23, 2001 2:27 PM > To: CF-Talk > Subject: Trouble with Dates > > > I'm try'n to get results back from MSAccess Access that are based on record > that fall in between 2 dates. I've tried a number of forming stabs at but > they all return 0 records. The date looks like this in Access "5/15/1998" no > quotes. > > WHERE ((Course.CourseDate) Between > #DateFormat(form.StartDate,"m/d/yyyy")# And > #DateFormat(form.EndDate,"m/d/yyyy")#); > > Any help is appreciated > > > Thanks in advance > > > > Doug Kronenberger > > OI National Training and Education Office > > Department of Veterans Affairs > > > > 440-526-3030 x7776 > [EMAIL PROTECTED] > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists