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?
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:
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:
(Source: https://community.alteryx.com/t5/Alteryx-Community-Resources/Alteryx-amp-Excel-Guide/ta-p/991380)
Good luck.
Thanks for the replay but this are not the case in above mentioned error
and if i remove the time from path then it is working only with date
Thank you it solved my problem
