Add datestamp to file name not working

I have a workflow that writes out 3 tabs of data to an Excel file from 3 branches, each using a Block Until Done and each tab is named according to its purpose.

I'm needing to have the file containing those 3 tabs date stamped but nothing I'm trying is working. Sometimes that stamp is in the data, sometimes it's the name of the tabs, never once has it been in the file name. :-)

Any pointers?

Output

Accepted answers

TeamTJ

When I ran your example, it simply changed the tab name, not the file name.

I WAS able to get it to work by creating a field called FileName and setting it to "C:\Temp\" + DateTimeFormat(datetimetoday(),"%Y%m%d-") + RestOfFileName.xlsx" and then in the output using the Change Entire File Path option and selecting FileName.

Unfortunately I had to do this for all 3 branches...fortunately I only have 3 tabs of data and not 10...or 20...or.... :-)

All comments

atcodedog05

Hi @TeamTJ

Try this post

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-include-a-timestamp-in-the-output-filename/td-p/63013

TeamTJ

I tried that one first and just tried it again. When your output file is .csv, it works great. When your file is .xlsx it includes the date/timestamp in the TAB name.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280