Hello all,
I am trying to create a workflow that will send an attachment by email every day. The filename changes reflecting yesterdays date in the filename. So the report send today would have this file name: Report_2015_12_22.csv (also note the underscores being used in the date)
I am using a Text Input tool to get the name of the attachment and then using a Formula tool to replace the date part in the attachment field. If the file name was using today's I would have already fixed it using this formula: 'C:\Apps\' + 'Report_' + Replace(DateTimeToday(),"-","_") + '.csv'
The output is C:\Apps\Report_2015_12_23.csv.
However to get yesterday's date in and replace the hyphens with underscores I am stuck and cannot get it to work.
I've attached a sample workflow and report.
Does anyone know how to accomplish this?
Thanks in advance!
Roel
edit: changed extension used
