1 Reply Latest reply on Apr 27, 2011 8:31 AM by philmodjunk

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

    macguy918_1

      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