I’m trying to get uipath to read the date format in dd.mm.yyyy for data entry in SAP for the attached testdate.xlsx (8.9 KB) . However, the data extracted and written into the report becomes any other date format whether it is dd/mm/yyyy or mm/dd/yyyy. May I know how to convert all dates no matter what format in the workbook into dd.mm.yyyy only? I tried the replace("/",".") but obviously it doesn’t work as it isn’t string.
Thanks so much in advance