>- see footer for list info -< Its been a long time since I used access, but I seem to remember it wanted something horrific like hashes around dates?
WHERE q.DateOfQuery BETWEEN ###start_date### And ###end_date### -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stephen Adams Sent: 31 January 2006 11:41 To: Coldfusion Development Subject: Re: [CF-Dev] Filtering using dates >- see footer for list info -< Hi Allan, Thanks, but when I tried this code you sent me I still got a Type mismatch in expression error. On 31/01/06, Allan Cliff <[EMAIL PROTECTED]> wrote: > > >- see footer for list info -< > Ooops think I missed out a CreateDate() there > > <CFSET start_date = > CreateODBCDate(CreateDate(Year(arguments.startDate),Month(arguments.star > tDate),Day(arguments.startDate)))> > <CFSET end_date = > CreateODBCDate(CreateDate(Year(arguments.endDate),Month(arguments.endDat > e),Day(arguments.endDate)))> > > Allan > _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
