How can I get the last day of a month in dynamic content in ADF2?

Question

I want to get the last day of a month based on the utcnow() timestamp.

Instead of "dd" in the expression bellow there should be automatically the last day of the month (28, 30 or 31):

@{formatDateTime(adddays(utcnow(),-2), 'yyyy-MM-ddT23:59:59.999')}

Thinking that it´s actually august I expect the following result out of the expression: "2019-08-31T23:59:59.999"

Answer 1

    @adddays(startOfMonth(addToTime(utcnow(), 1, 'Month')), - 1, 'yyyy-MM-dd')

More here:

Azure Data Factory - Expressions for Strings, Dates and More