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.