Monday, April 18, 2011

Yesterday's Date Expression with leading zeros

Right( "0" + (DT_WSTR, 2 ) MONTH(Getdate()),2)  +
(DT_WSTR, 8) ((DT_I4)Right( "0" + (DT_WSTR, 2 ) DAY (Getdate()),2)    -1) +
Right((DT_WSTR,4)YEAR(GETDATE()),2)