Trouble with FTP upload where file is different each month

[Voska]

New to Alteryx and have currently made something that is pulling from an FTP using text input and then using download.  My issue is comes with trying to automate this.  Currently its pulling from a static file on the FTP but to automate this it will need to run monthly with a different file name.  Examples: Reports_2017-03 for April, Reports_2017-04 for May, Reports_2017-05 for June.  How can i put something like a formula into the text input URL?

[Joe_Mako]

How about an expression like:

"Reports_"+DateTimeFormat(DateTimeAdd(DateTimeToday(),-1,"month"),"%Y-%m")

[Voska]

Thank you for the reply. It doesn't seem like you can put a function into the text input though for the FTP URL? That's the problem I see.

[Joe_Mako · Accepted solution]

Can you use a Formula tool?