SSIS Find & Reverse Function

Viewed 809

I am trying to get the date from the below filename using ssis expression.i get this file name from the variable

I have tried using findstring and reverse function but it still throwing cannot parse.

Any recommendtions pls

Variable

@[User::CurrentFile] : Z:\RETAIL DATA\HN_NLG\Supplier_report_by_Brand_Trend Micro_WC_20170327.xlsx

Need to get 20170327 and convert to 2017-03-27

Thanks in advance

2 Answers
Related