Viewing post 1 (of 1 total)
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).
November 15, 2013 at 2:44 pm
#1666849