Dynamical change the output file name with date and time both

[Ekmi9]

hello everyone,

I want to save my output file with current date and time using formula tool.

but when i try to run the file i am getting the error saying that file can not open.

can some one help me with this is issue?

[Yoshiro_Fujimori]

Hi @Ekmi9 ,

There are multiple potential reasons.

Please check the page below to see if any of the cases may be applicable to your issue.

"

Errors when outputting data:

• Error in the output tool: "unable to open file for write...-error opening file...the process cannot access the file because it is being used by another process".
• Output to Excel error: "We found a problem with some content..." Do you want us to recover as much as we can?...."
• Error: "Unable to overwrite a cell that contains a formula" when Overwriting Values in Excel

"

(Source: https://community.alteryx.com/t5/Alteryx-Community-Resources/Alteryx-amp-Excel-Guide/ta-p/991380)

Good luck.

[Ekmi9]

Thanks for the replay but this are not the case in above mentioned error 

[Ekmi9]

and if i remove the time from path then it is working only with date 

[Yoshiro_Fujimori]

@Ekmi9 ,

Thanks for the information.

Then colon ":" used in time could be the issue.

How about naming the file as below?

20230509_153000.xlsx|||Sheet 1

e.g. instead of

2023-05-09 15:30:00.xlsx|||Sheet 1

[Yoshiro_Fujimori · Accepted solution]

And it seems that Windows OS does not allow the file name with colon.

https://learn.microsoft.com/en-us/windows/win32/fileio/naming-a-file

Quote:

Naming Conventions

The following fundamental rules enable applications to create and process valid names for files and directories, regardless of the file system:

...

Use any character in the current code page for a name, including Unicode characters and characters in the extended character set (128–255), except for the following:

The following reserved characters:

< (less than)
> (greater than)
: (colon)
" (double quote)
/ (forward slash)
\ (backslash)
| (vertical bar or pipe)
? (question mark)
* (asterisk)

Unquote:

[Ekmi9]

Thank you it solved my problem 

[Madhu07]

Hi @yoshiro could you please which formula could result the same. thanks in advance.