Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Expression --need 2 digit not 4

    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).

Viewing post 1 (of 1 total)