Home Forums SQL Server 2012 SQL Server 2012 - T-SQL pass through query from access to sql-how can I select all records witha date greater than a fixed date RE: pass through query from access to sql-how can I select all records witha date greater than a fixed date

  • January 28, 2013 at 8:32 am

    #1581658

    I second Eugene (whose middle name may well be ssCrazy 🙂 ) - best practice is to use YYYY-MM-DD format when specifying dates in T-SQL:

    WHERE orderdate >= '2010-10-31'

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.