I use an ODBC link to download from a Sage accounting package into Excel.
I use the MSQuery "grid" to enter in my queries and I have recently had difficulties, not encountered before, when I have needed to use a clause limiting data to after a given date
[ The SQL should say something like WHERE WM_ORDERS.INVOICE_DATE > #30/11/2013#] I think I used to be careless in how I entered the date because MSQuery would add the hashes and correct the date format. Now, however I enter the date, I get an error message telling me there is a syntax error in the date.

I would like some help please with what the correct syntax for a date in MSQuery should be, and if possible what other areas might be impacting on my problem.

As I am not sure if this is the right forum to discuss this problem I am going to look for a SQL forum, and if I find it I will re post this.Please forgive me if this is a double post
John