Attachment using the genrated file but using the current date output

Question

Good Day,

Is there a possibility to attached an Excel file with the current date included in it is file name, I want it to be dynamically attach, since everyday I run the workflow and the file name of the excel file has a date on it?

Thanks In Advance

DataNath · Answer

Hey @Grail030510, does the daily file follow a standard naming convention? If so then you could make the FileName dynamically in a Formula tool, before appending it to your data stream just before the Email output and referencing this field as the file to grab. Here's how that looks:

1) Create the 'base' of your filename

2) Add the date using whatever formatting options you need

3) Append this to the main data stream

4) Reference the FileName field in the attachment options

Hope this helps!