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) r…

Hi @Jumbo Maybe this thread will help? :slight_smile: [image] String with Date into Date Format Help Try something like that [image]

Get datetime value from different date format from Excel

indra (Indra) July 19, 2018, 10:46am 2

@Jumbo follow this link

Topic		Replies	Views
Problems in DateTime Help	27	5883	October 29, 2018
Read Date from Excel Help excel	4	2764	September 18, 2019
Unable to change Date format in Uipath Help datatable , excel , activities	29	6101	August 8, 2019
Datatable date format has different format compared to source (.xlsx) Help datatable , activities , question	3	1598	January 13, 2020
(URGENT) Different date format to a standard date format Help	6	3443	June 14, 2019