AnsweredAssumed Answered

MS Query date Criteria

Question asked by philthomasp on Jul 18, 2017
Latest reply on Jul 20, 2017 by beverly

I have a query that I have created that I am having a strange issue with. First, the details:

 

Filemaker server is installed on a Mac server

ODBC connection is being made using a Windows 10 PC and MS Excel/Query

 

When I build my query everything is great until I add a date criteria. As soon as I add one and send the data to Excel, I can no longer edit said query. When I want to edit it from Excel, query opens but all I see is the data, I cannot do anything else to the table UNTIL I open the SQL box and manually delete the Date script.

Outcomes