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 th…

Reading CSV and Writing to Excel changes datatype

ddpadil (Dilip) December 27, 2017, 1:18pm 8

You just has to parse the date-time string,

Check this post for the reference.
Still same issue them please upload workflow with excel.

Topic		Replies	Views
String converting to DateTime Help activities , string , question , data_manipulation	6	2697	December 5, 2019
String was not recognized as a valid DateTime Conversion problem Studio datatable , excel , robot , studio , question , variables_management	3	2318	January 8, 2022
Excel to CSV. Date format not the same Help excel , csv , activities	1	4095	November 7, 2017
Convert date time excel to string Help excel , studio , question	6	2029	August 23, 2020
Date conversion from excel column Help excel , activities	14	2900	September 7, 2019