I have csv file in which Column1 has date and time value (String as column datatype).
I am using read csv to read.
I need to write this in excel. when I use write range. Here, some of the column1 values are storing as system.string and some of them as system.datetime.
Further I need to compare this column(excel) value with today’s date. but it’s showing error since it has two types of data
can anyone know why it is happening like this ?