Home Forums Reporting Services Reporting Services 2005 Development Select all records in current month RE: Select all records in current month

  • February 14, 2013 at 7:35 am

    #1587919

    Grasshopper:

    I think your query is wrong

    where DateFinished >= DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) and

    DateFinished <= DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) + 1, 0

    it will display from Jan1 to Feb1 in this logic

    It has to be

    where DateFinished >= DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) and

    DateFinished < DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) + 1, 0

    I guess 🙂