Date Format _001

  1. Using read range activity store the data in a variable DT1.
  2. using For each Row in Data table = row in DT1.
  3. using Assign Activity and write the conditions-
    row(“Column2”) = DataTime.ParseExact(row(“Column2”).ToString(),“dd-MM-yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“yyyy-MM-dd”)

if any query you ask me .