I am setting a variable in SSIS
package and I'm using this expression:
DATEPART("yyyy", GETDATE())*10000
+ DATEPART("month", GETDATE())*100
+ DATEPART("day",GETDATE())
The expression will give me a variable value like 'yyyymmdd'. My problem is that I want yesterday's date.
For example on 11/1/2014 it should be 20141031