CODEWITHSUNDEEP
azureexpressionazure-data-factory
eedwards
eedwards

Reputation: 95

Formatting month in Azure Data Factory V2

How do you format the date expression in ADFv2 so that you can get '1' for Jan and '10' for Oct?

I've tried using formatDateTime(dataset().date, '%M'), but I'm not sure this is the correct thing. I'm trying to set the folder paths for example 2019/1/1 and 2018/12/20.

Upvotes: 1

Views: 1751

Answers (1)

Murray Foxcroft
Murray Foxcroft

Reputation: 13745

You can find all the formatting options here and the function reference here.

I don't think you need the %, the following should work. 

formatDateTime(dataset().date, 'M')

Upvotes: 1

Related Questions