I ran into another situation that i can’t figure out. i have an excel and on a column i have the date, that is in the format 13.01.2021 - the info is extracted from some PDFs. i need to change that into date format so that i can compare with another column and see difference in days.
The thing is, regardless of what I’m doing, i can’t make it to work. In short lines, i read the excel into a DT, introduced a “for each row”, but everytime i try to convert it ( Datetime.ParseExact(variable,“MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture) it doesn’t work.
As always, a suggestion in the right path would be much appreciated.