Excel Output to Current Date with Data in 3 sheets

[danishrizvi]

Hello,

I have data being split into 3 different sheets of a single excel file. I am able to write to a static excel file (by naming sheets in the excel file) with 3 different tabs created, however I want the "excel" (not csv please) output in todays date and my data still being split into the 3 sheets within that file. 

[danishrizvi]

@JosephSerpis Jo - one last one. The WF you provided has datetimenow with 10 of left which is giving me the date. But as soon as I change it to 19 to get hh:mm:ss in the file name, it errors out as excel does not recognise : in a file name. Is there a work around to get hh-mm-ss instead?

[JosephSerpis]

Hi @danishrizvi couple of ways you can do this amend the workflow to show how.

[danishrizvi]

@JosephSerpis ignore the last part. I figured it out. Sorry for being a pain. And thanks a million for the help.

[danishrizvi]

@JosephSerpis I used this in the formula tool and worked out good for me. 

filename_" + DateTimeFormat(datetimenow(), "%Y-%m-%d %H-%M") + ".xlsx|||sheetName"

Thanks again.