Invoke code Error - Date

Help Forum
1

Uipath doesn’t recognize as a date value

ExcelTESTSejour.AsEnumerable().ToList().ForEach(Sub(row) row(“7”)=DateTime.ParseExact(row(“7”).ToString.Trim,“MM/dd/yyyy HH:mm:ss”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yy”))

image
image861×483 17.6 KB

image Classeur2.xlsx (9.1 KB)

2

Hi @Soudios !
Would you mind checking your data ? You need to check if all of the 7th column you’re targetting does not contain an empty value or another form of date (than MM/dd/yyyy HH:mm:ss)
Also, I think that you don’t need to use invoke code activity, try by using assign activity (left ExcelTESTSejour, right ExcelTESTSejour.AsEnumerable().ToList().ForEach(Sub(row) row(“7”)=DateTime.ParseExact(row(“7”).ToString.Trim,“MM/dd/yyyy HH:mm:ss”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yy”)) )

3

@Hiba_B

Here the excel file i use TEST EXCEL.xlsx (9.7 KB)