Excel File Name time stamp.

[nmccarthy82]

Hello, I am wondering if anybody knows how to update an output excel file name with a timestamp? I have tried changing the output tool to do this, but it seems like it will only update a sheet name and not the actual file name.

[JosephSerpis · Accepted solution]

Hi @nmccarthy82 I mocked up a workflow that shows how to do this. Let me know what you think?

[adriansteller]

I use this in one of my workflows but am finding that the timestamp is not 100% reliable. Example, you can see I've run a workflow that's saved my file at 9:30 but the timestamp says 9:11. 

I have tried various combinations to see how to update the timestamp:

- Delete files and run

- Close workflow, re-open and run

- Close Alteryx, re-open and run

- Close workflow, delete files, re-open and run

- Close Alteryx, delete files, re-open and run

My formula to populate the field is basically the same as the example posted: "filename_"+DateTimeFormat(DateTimeNow(),"%y-%m-%d_%H%m")

Every time, I'm getting a timestamp of 9:11...

Any ideas on how to get the timestamp to update?

[DanaO]

HI,

You shall replace the m with a captial M as in :"%y-%m-%d_%H%m"

[DanaO]

as in "%y-%m-%d_%H%M"

[adriansteller]

That did it. Thanks!