Adding the Date in out file

Question

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	EST2\Sales_2022-11-17 15:43:37.xlsx Can't open file: C:\Users\Ajith\OneDrive\Desktop	EST2\Sales_2022-11-17 15:43:37.xlsx: The filename, directory name, or volume label syntax is incorrect. (123)

Thanks
Ajith Reddy.

test23.yxmd

binu_acs · Accepted Answer

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

DataNath · Accepted Answer

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!