79469236

Date: 2025-02-26 09:50:37
Score: 0.5
Natty:
Report link

How to set date format to output date as "yyyy-MM-dd" in Azure Data Factory

Don't provide the default date format in the sink settings to get the expected output. Below is the process where i don't provide any default date format in the sink. So, the output is in expected format as you can see below.

Follow the below steps to get the expected output:

Step1:
Please try using the following expression without the default format to achieve the expected results: toDate(Date, 'dd/MM/yyyy', 'yyyy-dd-MM'). enter image description here

Step2: Based on your input, I have used the same sample data that you provided. enter image description here Step3:
I have provided the following expression in the derived column as required. Please use the following expression in the derived column as required: toDate(Date, 'dd/MM/yyyy', 'yyyy-dd-MM'). enter image description here Step4: I'm generating the output in CSV file format as per your requirements. enter image description here

Reasons:
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Starts with a question (0.5): How to
  • Low reputation (1):
Posted by: Jagadish S