Data Dynamic Azure Data Factory

Question

good afternoon!

I’m doing a project in which I upload data from SAP to my SQL, via Azure Data Factory. It turns out I need to have a dynamic column Partition, by date:

I need, for example, to take this date dynamically: 20200901

And also exist in the tool pre-existing pre-functions, eg:

The point is that I need to format this date, so instead of coming "2020-09-01T00:00:00.0000000Z", come like this "20200901"

Any help is welcome!

Thank you!!! :)

Answer 1

Solved

@{formatDateTime(getPastTime(1,'Day'),'yyyyMMdd')}