Adding the Date in out file

[Sarreddy]

Hi Team,

I have create a excel as a file output, in this case I would like change file location by passing the path throughout formula tool.
But when ever I have add a Sheet name included date and time getting a issue.

if I'm excluding date and time stamp I can get exact required output from the workflow.

ERROR :: 

Output Data (12) Unable to Open archive for zipping: C:\Users\Ajith\OneDrive\Desktop\tEST2\Sales_2022-11-17 15:43:37.xlsx Can't open file: C:\Users\Ajith\OneDrive\Desktop\tEST2\Sales_2022-11-17 15:43:37.xlsx: The filename, directory name, or volume label syntax is incorrect. (123)

Thanks
Ajith Reddy.

[binuacs · Accepted solution]

@Sarreddy I think the time format causing the error. Can you update your formula like below and try

[DataNath · Accepted solution]

Hey @Sarreddy, this issue is coming from you plugging the DateTimeNow() directly into the filename... As it is in the YYYY-MM-DD HH:MM:SS format, this contains colons (:) which are illegal characters when trying to save an Excel file.

See here before replacement I get the same error:

However, if I just replace the colons with something different i.e. a dash, it works fine:

Obviously you can replace them with anything, I just used hyphens to demonstrate. You can also change the format entirely with DateTimeFormat().

Hope this helps!

[Sarreddy]

Hi @DataNath @binuacs  Thank you so much. It's Woking perfectly.😊