Update value with formula action not working

[jhustin]

I am trying to pull files from a directory where the filepath will change each day. The current date will be in the filepath so I am trying to use an Update value with formula action so I can dynamically have this pull each day. The directory does not change based on what is in the action, however. It just runs for what is in the directory tool and ignores the action attached to it.

[apathetichell]

Yes,. See my post re: macro -  10 minutes ago.

[jhustin]

Thank you. I am not quite sure I follow. Would you be able to help with a basic exmaple?

[apathetichell]

Try this - if you have an older version of Alteryx just ignore the newer version errors. Open the file manually after unzipping.

[michaelhimmel]

Could you just use the "Include Subdirectories" option on the Directory tool and move the directory up a level?  So instead of having this formula 

"C:\Reports\"+tostring(DateTimeFormat(DateTimeToday(),"%d-%m-%Y"))+"\POSD039 - Customer - Monthly Shipment Data"

on the directory field, just have "C:\Reports\" as the directory:

And then filter on the output field "Directory" using your formula to limit it to the particular date/value needed.