Hi everyone. I have 2 excel files with same format . But i dont understand why it read cell ( date format ) from 2 files are different. Ex. File1: 12/11/2020 ( dd/MM/yyyy ) . it read correct into 12/11/2020 File2: 12/11/2020 (dd/MM/yyyy). but it read incorrect into " 11/12/2020 00:00:00 " H…

Issue when read date format from excel

Mr.H January 7, 2021, 9:34am 4

Thanks you everyone.

Topic		Replies	Views
Excel Read - Date Format Issue Help excel , activities	3	1231	August 27, 2020
Problems in DateTime Help	27	5878	October 29, 2018
How does read range works on date columns in excel? Activities excel , activities , question	11	2963	March 11, 2021
DateFormat Issue Help	6	1118	June 3, 2020
Datatable date format has different format compared to source (.xlsx) Help datatable , activities , question	3	1596	January 13, 2020