AnsweredAssumed Answered

Timestamp format for Microsoft Query (Mac) thru FMP to Microsoft SQL Server 2005

Question asked by macguy918_1 on Apr 27, 2011
Latest reply on Apr 27, 2011 by philmodjunk

Title

Timestamp format for Microsoft Query (Mac) thru FMP to Microsoft SQL Server 2005

Post

I am trying to retrieve data from a Microsoft SQL Server 2005 database into Microsoft Excel using Microsoft Query on a Mac.  There are some timestamp fields in the SQL Database that I need to use as criteria for selection.

I want to select only those records whose datefield is 04/26/2011.  I have tried all sorts of combintations #04/26/2011#, '04/26/2011', 04/26/2011, etc., and I keep getting errors that the format for that field is incorrect and I therefore have a syntax error in the SQL query.

Does anyone know what format to use in this case.  Again, the database view from the SQL Server 2005 database is shown as a timestamp field.  

thanks

Outcomes