Update Output File name using Text Input and Interface Tools

[calvincarr29]

Is there a way to use interface tools to update the name of the Ouput File from values in a Text Input tool?

I would like my output Excel file to say: "Existing Layer_12/31/2024" - having the date be updated based on text in Tax Year End column. 

[Carolyn]

A problem that you're going to run into is that you can't have a forward slash in your file name

Here's what I would do to solve it. I don't know if you necessarily need an Interface Tool, without seeing your full workflow.

1. Add an Append Tool to append the Date that you want (Tax Period End) onto your main data workflow
2. Formula Tool to create a File Name column using the Tax Year End
   1. This also includes a Replace to change the "/" to either nothing (csv path) or to a "-" (xlsx path)
3. Output Tool where you take the Entire File Path from the File Name field that you just created
4. Options are included for both xlsx and csv