This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to save an output file (*.xslx) with date and time but not able to do so.
When using formula "XXX\4april\"+TOSTRING(DateTimetoday())+"_outputfile.xlsx|sheet1", it is working fine but file getting saved as XXX2017
When using formula "XXX\4april\"+TOSTRING(DateTimenow())+"_outputfile.xlsx|sheet1", getting the below error
Unable to Open archive for zipping: XXX\4april\2017-04-07 12:55:43_outputfile.xlsx Error Opening file: \4april\2017-04-07 12:55:43_outputfile.xlsx: The filename, directory name, or volume label syntax is incorrect.
I used the method "XXX\4april\"+replace(DateTimenow(),":","")+"_outputfile.xlsx|sheet1" to populate the time stamp onto the output file name. Unfortunately, this gave me a file per execution second. To get a single file name for the execution of the workflow I was forced to manipulate the time portion replacing the second digit of minute and both digits of seconds with zeros.
Below is how I accomplished the task returning File_Name_20171010_175000