I see the problem is already solved but i wanna reffer to another link where you can vote to improve this feature in UI_Path:
I will re-write my solutions because each time i face this problem i improve a bit my knowledge about date formatting.
The usuall problem is about culture info (language) in this case the date format in spain is dd/MM/yyyy and Excel Activity convert it to Date, if the day is 12 or less it reads the date as MM/dd/yyyy (swaps month and day) but when is more than 12 it reads it properly
For all of you that would need to work with strings and datetime remember that you can use .tostring(“dd/MM/yy HH:mm:ss”) notation to convert to string in different formats. And also you can use DateTime.parse(dateTimeAsStringInAnyCultureFormat, new system.globalization.CultureInfo(“Es-es”)) to read any different culture dates. de “ES-es” could be changed to other formats just look in then MSDN
I have been struggling with this problem again and a collegue recommend me to work with FormatValue activity that mostly resolves all this problems.
Finally for all of you that should use the parse solution al ot in the same workflow just remmber that you can set the system.globalization.cultureinfo.currentculture to new system.globalization.cultureinfo(“Es-es”) at the start of the workflow and will save your culture selection for all parses