i was trying to read and convert a value from the Config.xlsx file to a date format as shown below using an assign statement.
DateTime.ParseExact(in_Config(“validDate”).ToString, “yyyy-MM-dd”, System.Globalization.CultureInfo.InvariantCulture)
I run into the following error.
Assign - Filter Date: String was not recognized as a valid DateTime.
Existing solutions on the forum didn’t work … Appreciate your help. here is the excel value: