Dynamic File Name


I’m new to automationedge. I’m trying to read the SQL data and pass it into Excel writer.

The process is working fine as expected. However, I want the filename as a dynamic value in the belowformat

I.e. ddMMyyyyHHMM_Sample.xlsx

I’m not sure how to generate this dynamic value and pass it to filename attribute for Excel Output action

1 Like

Hi! Priya

I suggest in The Excel Writer step you use the date options-
Include date in filename
Include time in filename
specify Date Time format

Generally the popular date format starts with Year followed by Month, Date, Hour and Seconds.

1 Like