Home Forums SQL Server 2005 Business Intelligence Expressions for Variables RE: Expressions for Variables

  • October 19, 2009 at 2:59 pm

    #1067844

    so using...

    DatePart("mm", GETDATE()) == 1 ? "012" : "0" + (DT_WSTR,30)(DatePart("mm", GETDATE()) - 1)

    doesn't work?

    (added the minus one at the end).

    Steve.