Home Forums SQL Server 2005 SQL Server 2005 General Discussion Last Year to Date report parameter RE: Last Year to Date report parameter

  • September 15, 2010 at 8:48 am

    #1221393

    1. Change "Today" to "GetDate()".

    2. In your example, you want the date range to end on 9/14/2010. I assume this is a typo, and should be 9/14/2009?

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2