Share via

first date of the month - dataflow

arkiboys 9,701 Reputation points
2022-04-21T06:20:51.08+00:00

In pipeline I want to pass in dates to dataflow, I use this to get the current date --> @convertTimeZone(utcNow(),'UTC','GMT Standard Time')
How do I get the first DATE of the current month? example: 2022-04-01
Thank you

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,252 questions
0 comments
Accepted answer
  1. Nandan Hegde 34,171 Reputation points MVP
    2022-04-21T06:33:44.263+00:00

    Hey,
    195012-image.png

    learn.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions#startOfMonth

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.