AnsweredAssumed Answered

SQL Microsoft Query to return dates greater than 1/1/2013 not working

Question asked by dwirony on Aug 21, 2018
Latest reply on Aug 21, 2018 by beverly

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:

 

SELECT "MyDatabase"."MyDate"

FROM "MyDatabase"

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?

Outcomes