I'm using ODBC in Excel to connect to a remote FMP server. I'm trying to just pull dates for after 1/1/2013 by using this query:
WHERE "MyDatabase"."MyDate" >= '2013-01-01'
But it's returning nothing. My values are formatted as dates in m/d/yyyy in the FMP server. Any idea what I'm missing?