I need your help here please.
I have an excel table with date entries in the form 03.08.2020 16:22.
This is the German format (dd:MM:yyyy hh:mm)
In excel I formatted the field into user-defined as TT.MM.JJJJ hh:mm which is the same as above in German.
The problem is that UIPath switches date and month, which leads to errors like this one:
Get Row Item of the column Process Start Date: 16.09.2020 08:00 is not a valid value for DateTime.
Does anyone know how I can solve this?
Thank you in advance!