Date and Time stamp to excel output give error incorrect syntax

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

Error Message

Accepted answers

apathetichell

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

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

05270Mavericks334.yxmd

All comments

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703