Date and Time stamp to excel output give error incorrect syntax

[Mavericks334]

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

[apathetichell]

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.

[Mavericks334]

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

[apathetichell · Accepted solution]

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.

[Qiu · Accepted solution]

@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.

[Mavericks334]

Thank you it worked like a charm

[Qiu]

@Mavericks334 

Glad to help and thank you for the accept mark, 😁