Save Excel with Date and Time

[Hursan]

I have this workflow that I want the output to include the date and time.

If I use:

"....\Database\AutoReports\Data_For_Shipping_Manifest\All_Data\Reports_Data_For"+"_"+ DateTimetoday()+".xlsx"+"|||Sheet1"

the file is successfuly created with the date only

but if i use

"\...\Database\AutoReports\Data_For_Shipping_Manifest\All_Data\Reports_Data_For"+"_"+ DateTimeFormat(DateTimeNow(),"%d%m%Y %H:%M:%S") +".xlsx"+"|||Sheet1"

I get an error.

Same if use:

"\...\Database\AutoReports\Data_For_Shipping_Manifest\All_Data\Reports_Data_For"+"_"+ DateTimeNow() +".xlsx"+"|||Sheet1"

What am I doing wrong?

Any help is greatly appreciated.

[Matt_D · Accepted solution]

Hi @Hursan  if you're on Windows, try and save a file with ":" in the filename.

You'll need to use "%d%m%Y %H%M%S" 👍