Hi, I have a excel sheet which has a “Date of Birth” column with values such as “1977-11-02 00:00:00.0”. The robot machine’s datetime format is MM/dd/yyyy which kept the column in General format in Excel.
What I was trying to do was to get row value and write a log message, and I’ve set the output of the value to variable type string. But this particular row “1977-11-02 00:00:00.0” has been throwing me “String converter cannot convert from Datetime” error while writing log message but worked for other rows such as “1988-08-16 00:00:00.0”.
I get that if I set output variable type to generic value and add .ToString at log message would have solved this. But I would like to know why it worked previously and doesnt for this case.