Create New with date and time, when workflow is run

[BRRLL99]

Hi Team 

I'm looking to create new excel file with single sheet whenever the workflow is run

ex:

If i ran the workflow at 07-11-2023 5:00 PM 

file should be created as sample 07-11-2023 5:00 PM 

I have ran the same workflow at 07-11-2023 5:10 PM 

file should be created as sample 07-11-2023 5:10 PM 

Sample file has been attached please look into it

[alexnajm]

It would be a Formula tool creating the path you would want to write it to! I am not sure the folder or extension, so here's an example that will just save to the same location as your workflow:

"sample "+DateTimeNow()+".csv"

If you want to format the current time, surround the entire thing with DateTimeFormat and specify your format with these specifiers: DateTime Functions 

[mceleavey · Accepted solution]

Hi @BRRLL99 ,

As @alexnajm mentioned, you need to create a formula which will append the formatted datetimenow() function to the name of the sheet.

You then need to consider the output hitting the same file (potentially) at the same time, and so I've used the new Control Container functionality to control the sequence.

If you do not have the latest version of Alteryx then you'll need to build the batch macro output method.

I've attached the workflow. 

I hope this helps,

M.

[ahsanaali]

See if this works for you.

Note: cannot use colon (:) in the file name.