Hi all expert,
I have a problem to read date from Excel. I have 2 separate Excel that both have date but different date format and one (yyyy/mm/dd) can be read and possible to parse date time format but other one (dd/mm/yyyy) is not, (See also attachment as sample.)
ReadCell(日付).xaml (6.1 KB)
readCell(日付).xlsx (9.3 KB)
Does anybody know good way to convert multiple date format to uipath datetime format??
*I know one way by using separate by “/” but that somehow bothersome so I need good way to read it.
Thanks in advance,
J,