• How would I get the previous month?

    I need my file to be renamed Mods201001.xls.

    Here's what I have

    @[User::SharePath] +

    RIGHT("0" + (DT_STR,4,1252) DatePart("yyyy",getdate()),4)+

    RIGHT("0" + (DT_STR,4,1252) DatePart("m", getdate())-1,2)

    But I get an error -

    Attempt to set the result type of binary operation ""0" + (DT_STR4,1252)DatePart("m",GETDATE))-1" failed with error code 0xC0047081