Forum Discussion
Dynamic dates in Azure Data Factory
Dear Folks I am trying to copy the data from the Azure SQL table to the CSV file in Azure Data Factory. CSV Filename must be appended with below date Filename_11_07 Where Filename --> comes from ...
I believe yes, you can manipulate dates in Azure Data Factory (ADF) dynamic content using built‑in functions like formatDateTime(), utcNow(), and addDays(). To get the last Sunday date and append it to your filename, you may required to calculate the offset from the current date and format it accordingly.