troubleshooting Question

Access will not allow date criteria on a .xlsx linked table

Avatar of Cole100
Cole100Flag for United States of America asked on
Microsoft Access
5 Comments1 Solution107 ViewsLast Modified:
Using Access 2016. Exporting data from Survey Monkey into an .xlsx file. In Access a created a linked table. I build my queries and try to use various date criteria's and Access will not return any results. My linked table for the date field is set as Date/Time with the format of yyyy-mm-dd h:nn:ss

Very simple query returns nothing. Remove date criteria and I see everything as would be expected. Yes, I have data that Date()-1 would pull. Using specific dates do not work either #11/05/2018#

SELECT SurveyMonkey.StartDate, SurveyMonkey.StoreNumber, SurveyMonkey.ServiceExperience, SurveyMonkey.ServiceTime
FROM SurveyMonkey
WHERE (((SurveyMonkey.StartDate)=Date()-1));

Using 'Between DateAdd("d",-DatePart("d",Date())+1,Date()) And Date()-0' pulls data without issue.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
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 5 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