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 24, 2013 at 9:56 am

    #1580620

    I have tried the following without success

    WHERE orderdate >= '31/10/2010'

    Any error returned?

    Anyway, whenever you are using date strings, make sure they are in non-locale dependent format. Best is ISO: YYYY-MM-DD (YYYYMMDD will also work) , or you can use words for month: '31 Oct 2010'

    so:

    WHERE orderdate >= '20101031'

    or

    WHERE orderdate >= '31 Oct 2010'

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]