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
Using 'Between DateAdd("d",-DatePart("d",Date())+1,Date()) And Date()-0' pulls data without issue.