ADF Expression - 1st Date of the Prior Month

Mike Kiser 1,531 Reputation points

I have the following requirement and need to use it in an ADF Expression: I have thought about this but how would I put this into a Variable (see the following) so that I can later insert it into a Table in an SQL DB?

@MartinJaffer-MSFT @Nasreen Akter


Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,451 questions
{count} votes

Accepted answer
  1. Nasreen Akter 10,706 Reputation points

    Hi @Mike Kiser ,

    Please try the following expression. Please pass the date instead of '1/1/2019'. Thanks!

    @formatDateTime(subtractFromTime(formatDateTime('1/1/2019', 'M/d/yyyy' ), 1, 'MONTH'), 'M/1/yyyy')  


    If the above response is helpful, please Accept as answer and Up-vote it. Thanks!

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful