I am reading data from my date column from excel file in the format ( mm/dd/yyyy) & (m/dd/yyyy), spliting it in mm/yy format and again writing in new column.
I am getting error message as " String was not recognized as valid datetime".
Although uipath writes data in my first column.
I need to split " Transaction Date" as mm/yy or m/yy and write to column “Period1”
Attached is the xls file and xaml.