Home Forums SQL Server 2005 SQL Server 2005 Integration Services Expression --need 2 digit not 4 RE: Expression --need 2 digit not 4

  • November 18, 2013 at 5:11 am

    #1667095

    alane 46264 (11/15/2013)

    Replace

    (DT_STR,4,1252) DatePart("yy",getdate())

    with

    Right((DT_STR, 4, 1252)DatePart("yyyy", getdate()), 2)

    This will return the last two (Right) digits of the year (ignoring the "20" century).

    You just answered a five-year-old post - hope that they were not sitting there waiting! 😀

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.