How to get exact date format ("MM/dd/yyyy") from the excel

Help Activities
, ,
4

Hey!

Try this:

  1. Read excel using read range output as → Dt_Out
  2. Take one for each row in data table activity and pass the Dt_Out

Now take one assign activity and create one string variable called InputDate and pass the expression like this…

Datetime.ParseExact(CurrentRow("ColumnName").ToString, "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy")

Regards,
NaNi