I’m on Studio.
I’ve an spreadsheet that has 2 columns with date. I’m comparing the ‘Issued Date’ column with Today’s date.
Here’s what I’m doing - Read the file into DT. In the For loop DT, I do as Assign
MyInvDate = DateTime.ParseExact(CurrentRow.Item(“Issued Date”).ToString, “MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture)
(MyInDate is of DateTime type)
In the If statement, I write MyInvDate >= DateTime.Today and Write Line MyInvDate.ToString
It shows error - String is not recognized as a valid date format.