Dynamic File Name with Datestamp

[PriyaSinha]

HI Community,

I’m new to here. I’ve created a simple process where I will get the data from SQL and create the excel file which is working as expected.

However, I want to create a dynamic file name in the format: DDMMYYYYHHMM_ExportData.xlsx.

I tried many ways, but no luck. How can I create a variable with the above format name and pass it to exceloutput file name attribute

[seema.kothari1]

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.