Hi, I am trying to read the German date format somehow in Excel and to read this date with the same format as it is in the Excel table. In this case, the German date format has the double format. [grafik] datetest.xaml (5.6 KB) testdate.xlsx (8.2 KB)

@Crusha In the Message Box use this : DateTime.FromOADate(read) Check if it gives you the Date Value.

Excel (ger) Date (double) read and paste

balupad14 (Balamurugan) July 28, 2020, 8:47am 2

Check this one.

Here is the video demonstration

Regards
Balamurugan.s

Topic		Replies	Views
Format date in excel not match file original? Activities excel , activities , question	7	1138	June 6, 2021
Date Format in Excel Reading Activity Help studio	6	8955	December 6, 2022
Format date in excel Activities excel , activities , question	9	917	June 4, 2021
(URGENT) Different date format to a standard date format Help	6	2698	June 14, 2019
Format or value of excel data changes Help	3	1468	August 21, 2020