troubleshooting Question

Trouble with WHERE using OleDbCommand and DataTime

Avatar of curiouswebster
curiouswebsterFlag for United States of America asked on
Microsoft Access.NET ProgrammingSQL
3 Comments1 Solution226 ViewsLast Modified:
I have an Access database with a text column called CreationDate. The format of the field is '2/2/2010', for example. No leading zeroes for month or day fields.

This WHERE does not work. There are no exceptions, but valid data does not get retrieved.

WHERE Format(CreationDate, 'MM/dd/yyyy') >= '2/18/2010' AND Format(CreationDate, 'MM/dd/yyyy') <= '2/20/2010'

Any suggestions? There are no records returned by this query, even though I can see there are multiple. This problem may force me to dig deep and find a much bigger work around., which I really do not want to do.

Thanks for any help.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros