Error - The filename, directory name, or volume label syntax is incorrect

Question

I want to generate excel files with date and time stamp on file name after every run. I have attached the snapshot of the formula I have used. The output path is correct but I am getting the below error

Output Data (276) Unable to Open archive for zipping: Output\COAC Event Diary 2025-04-30 05:07:19.xlsx Can't open file: Output\COAC Event Diary 2025-04-30 05:07:19.xlsx: The filename, directory name, or volume label syntax is incorrect. (123)How to rectify this?

Output Path Formula.PNG

binu_acs · Answer

@saachitalwar try DateTimeToday() instead of DateTimeNow() function in the formula tool

Qiu · Answer

@saachitalwar 
One reason for sure is that ":" is an illegale character to use in the File path for Windows. Maybe you can simply remove these ":".
Output\COAC Event Diary 2025-04-30 05:07:19.xlsx