Syntax Error when Specifying Date Criteria in MS Query (Excel 2010) using Windows 10

I Recently Upgraded my OS from Windows 7 to Windows 10. I am using an ODBC connection string to extract data from a Sage Database file. The Extract worked perfectly in Windows 7. I use the Query wizard in Excel. I have a Where Clause that only selects date based on the DATE field. I select records That are greater than 31/03/2014 and Less than 01/04/2015. This works perfectly in Windows 7. In Windows 10 I get a SYNTAX ERROR. I have tried formatting the date in different ways(2014-03-31 or 2014/03/31. I have even tried to use the Underlying number for the date. If I do this, I get told to format the date in yyyy/mm/dd format. Has anyone else had this problem?

This thread is locked. You can vote as helpful, but you cannot reply or subscribe to this thread.

Replies (2)

AlastairMorgan

I have not Received an answer. I was able to re-check the error by using a colleague's computer running Windows 7.I was able to create a workaround which involved Filtering the Data in Excel 2010. However that involved Extracting over 9000 records instead of just 1975. Microsoft really need to address this issue

4 people found this reply helpful

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

AlastairMorgan

This Issue is now Resolved. I had to Update the Language settings on My Coputer to Enable Cortana to Work Properly. Since I Downloaded the Laguage Pack and set my Default Language the error has disappeared.

Syntax Error when Specifying Date Criteria in MS Query (Excel 2010) using Windows 10

Replies (2) 

Question Info

Replies (2)