locked
DatePart Year RRS feed

  • Question

  • Group, I am building a report in SSRS that has a dynamic title, concatenate to the month (which is 2 months back from GETDATE) concatenated again , but now I want to add the Year, but it also has to be the year 2 months ago.  So something like:

    MonthName(Month(Today())-2) & " " & (Expression to display year two months ago)

    Hope this makes sense... Year(Today()) won't work because if the report runs in Feburary the data in the report is actually for December 2008 not 2009

    • Edited by tous0024 Thursday, May 28, 2009 7:00 PM format
    Thursday, May 28, 2009 6:58 PM

Answers

  • Hi,

    Try this:

    =Format(Today().AddMonths(-2),

    "MMMM yyyy")

    Good luck.


    Chicagoan ...
    • Marked as answer by tous0024 Thursday, May 28, 2009 7:10 PM
    Thursday, May 28, 2009 7:05 PM
    Answerer