I am looking to pull a date from excel (MM/dd/yyyy format in excel) and type the row of dates into a website for each row of the excel. I will then need to type another date into the website that is 30 days after the first date that was typed into the website.
I can type the first date in perfectly fine by passing the date as a string, however the second needs to be DateTime formatted to handle the addition of the 30 days the bot will be adding.
I am having issues with the “String was not recognized as a valid DateTime” error at the moment.
Legend: = Activity input area
Read Range - ExcelData (Variable datatable output)
For Each Row - ForEach [row] in [ExcelData]
[InputDate] = [DateTime.ParseExact(row(“DOS”).ToString, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture)]
Type into - [InputDate]
Type into - [InputDate.AddDays(30).ToString(“MM/dd/yyyy”)]
Variables: - Excel Data = DataTable (Variable type)
InputDate = DateTime (Variable type)