CODEWITHSUNDEEP
azure-data-factory
ADF-Learner
ADF-Learner

Reputation: 25

Error date time string must match iso 8601 format in ADF

I have datetime string containing value 12/20/2023 04:57:00.

I need to create file using copy activity from this string like 20231220_045700.parquets when I am using formatDateTime function to get date and time I am getting error the datetime string must match iso 8601 format.

Is there any other way to do this

Upvotes: 0

Views: 274

Answers (1)

Rakesh Govindula
Rakesh Govindula

Reputation: 11529

Is there any other way to do this

Use the below expression in the copy activity filename to achieve your requirement. Here, date variable contains the input string 12/20/2023 04:57:00.

@concat(formatDateTime(variables('date'),'yyyyMMdd_HHmmss'),'.parquet')

enter image description here

Result:

enter image description here

Upvotes: 0

Related Questions