Re: [DFW CFUG] Trouble Obtaining a date range from an ACCESS database

[Christopher Jordan]

Ray, I'm guessing that the pound signs worked? I found the following on the MS Knowledge base http://msdn.microsoft.com/archive/default.asp?url=""> Chris Christopher Jordan wrote: So access doesn't understand the ODBC date format? (i.e. {d 'YYYY-MM-DD'} ) hmm... I didn't know that. :) Chris Ryan Everhart wrote: Ray, I just tried some stuff and this is what I came up with...  try adding, if you can, pound signs and remove the single ticks.  I'm not sure why, but some how this tells access that it is a date.    WHERE dateCreated BETWEEN #2006-01-05# AND #2006-01-11# Note I tired this in Access stand alone, not through ColdFusion to Access. Ryan On 7/10/06, Ray Hughes < [EMAIL PROTECTED]> wrote: Hi All, Thanks everyone I am still searching. Regards This query: SELECT dateCreated FROM cars WHERE dateCreated BETWEEN '2006-01-05' AND '2006-01-11' Returns an error Error: Data type mismatch in criteria _expression_. (State:22005, Native Code: FFFFF42A) This query: SELECT dateCreated FROM cars WHERE dateCreated BETWEEN {d '2006-01-05'} AND {d '2006-01-11'} Returns ZERO Records _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ _______________________________________________ Reply to DFWCFUG:   List@list.dfwcfug.org Subscribe/Unsubscribe:    http://lists1.safesecureweb.com/mailman/listinfo/list List Archives:     http://www.mail-archive.com/list%40list.dfwcfug.org/    http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors:   www.HostMySite.com   www.teksystems.com/ -- Ryan Everhart [EMAIL PROTECTED] _______________________________________________ Reply to DFWCFUG: List@list.dfwcfug.org Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/ _______________________________________________ Reply to DFWCFUG: List@list.dfwcfug.org Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/

_______________________________________________
Reply to DFWCFUG: 
  List@list.dfwcfug.org
Subscribe/Unsubscribe: 
  http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives: 
    http://www.mail-archive.com/list%40list.dfwcfug.org/             
  http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors: 
  www.HostMySite.com 
  www.teksystems.com/