locked
DatePart Year RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    1
    Sign in to vote
    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