Hi All, Below is the date column and I want to remove the trailing and leading spaces from the date.
I have used the following code:
For Each Row
row(“Date Column”) = row(“Date Column”).Tostring.Trim
but afterwards, I want to compare the date with other static date, for example:
CDate(row(“My_Column”)).Date <= My_Another_Date_Col
It gives me an error i.e., “Conversion from String “22/02/2019” to type ‘Date’ is not valid”.