I have a situation where I need SSIS to look for a filename with the date of the previous Wednesday. We have a fiscal week that ends on Wednesday and a file is generated in the format of abcd_yyyymmdd.txt where the date is that Wednesday marking the end of the fiscal week. The file is usually processed on the next Thursday but it could be processed on Friday or possibly even the following Monday. So I need the expression to check for the current day of the week and find the correct date for the previous Wednesday.
I know how to get the date into the filename it is just the logic for finding Wednesdays date that I am unsure of when creating an expression.