Home Forums Reporting Services Reporting Services Date query in SSRS RE: Date query in SSRS

  • December 13, 2017 at 5:00 am

    #1971919

    First day of previous month:
    =DateAdd("M", DateDiff("M", "01/01/2000", Today())-1, "01/01/2000")
    Last day of previous month:
    =DateAdd("d", -1,DateAdd("M", DateDiff("M", "01/01/2000", Today()), "01/01/2000"))

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk