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: [email protected] 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 via email to