How to append file name with date

Question

I want to add dynamic file names to my sink file as export data_date but the date should be in 10days difference when pipelinerundate in adf.

Answer 1

Hey,

You can use dynamic expression to achieve that :

@concat(pipeline().parameters.FileName,adddays(pipeline().TriggerTime,10))

where below represents the 10 days diff

adddays(pipeline().TriggerTime,10)

Note : you would also have to concat the file extension at the end

Answer 2

Hi Snv, Sudhir K, Welcome to Microsoft Q&A platform and thankyou for posting your question here.
In addition to the information provided above, please refer to this GIF for a more detailed demonstration.

I have used the following expression at the sink: @concat('export data_',adddays(utcnow(),10)) based on your requirement.

I hope this will help. Please let us know if any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.