troubleshooting Question
Trouble with WHERE using OleDbCommand and DataTime
asked on
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.
newbieweb
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.
newbieweb
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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.