Date Subtraction in Expression

[IAMINFO]

Hello everyone I am totally stuck, I am trying to subtract 1 day from the day part of this expression, appreciate your help, thank you for reading the post.


@[User::FileDate] +
(DT_STR,4,1252) DatePart("yyyy",getdate()) +
Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2) +
Right("0" + (DT_STR,4,1252) DatePart("d",getdate()),2) + ".csv

 

[IAMINFO]

Thanks everyone I figured it out. Here is the syntax if anyone needs it

@[User::FileDate]
+ (DT_WSTR,4)YEAR(DATEADD("dd", -1, GETDATE())) + "-" + RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("dd", -1, GETDATE())), 2) + "-" + RIGHT("0" + (DT_WSTR,2)DAY(DATEADD("dd", -1, GETDATE())), 2) + ".csv