Hi,
I'm adding the date and time stamp to an excel output using a formula option and it gives me the below error. If i try to save the file without date and time extension it works fine. This is the formula that i'm using
'E:\Alteryx Workflow\Open Notices\Open Notices TEST_'+
DateTimeNow()+
'.xlsx'+
'|||Sheet1'
Settings of the file.
Regards,
Renato
Solved! Go to Solution.
can you post your field Test and the format of the date time stamp?
Also - you should have this set to write to a new file since presumably there is no file in existence with the same timestamp - You have this set to overwrite existing sheet.
Field is being created by this formula
E:\Alteryx Workflow\Open Notices\Open Notices TEST_'+
DateTimeNow()+
'.xlsx'+
'|||Sheet1'
Date and time stamp by function DateTimeNow() which is 2021- 05-26 17:30:33
also - replace the ":"s in the datetime with "." or "_" or something else which isn't a key identifier in file systems.
I used:
replace("this is a test"+ tostring(datetimenow())+".xlsx|||'sheet1'",":",".") and it should work for your case after you change to create new...
left out the .xlsx above so I updated it.
@Mavericks334
As @apathetichell pointed out, the ":" is an illegal character for File path or name in windows.
so we have to replace it with someone else.
Thank you it worked like a charm
Glad to help and thank you for the accept mark, 😁