Date Transformations in Derived column – Azure Data Factory

In my Azure Data Factory journey, everyday is a new learning. Creating ADF can be referred here

Defaulting date to current date is common. I had to requirement to default the date to last date of the previous month. Thus, when I import the data in April month, the date to be set as 31.March.2021 , for May month it will have the value as 30.April.2021 and so on.

With Derived column in Azure Data factory, converting the field values is uncomplicated.

I had to use the expression to default the date

lastDayOfMonth(addMonths(currentDate(), -1))

This change can be immediately confirmed by using a Data Preview option in Derived column

Click on ‘Data Preview’

Easily converted without any hassles.