Issue: I am having trouble with a date formatting issue using parsing.
GOAL: Convert all dates in column G from yyyy/dd/MM to ddMMyyyy
- I am using an excel application scope to read my file and create an output data table.
- I then use a ‘for each row’ activity to loop through the rows. I am using an assign activity to create a variable “myDateTime” = Row(“Effective Date”).
- I then use another assign activity to parse the date (DateTime.ParseExact(row(“Effective Date”).ToString,“yyyy/MM/dd”,System.Globalization.CultureInfo.InvariantCulture).ToString(“ddMMyyyy”).
- I then use a write range activity to write the data from the DTData table to the file specifying the column to return the values. I receive an error message "The string is not a recognized as a valid date/time.