In my excel, this is my date format: [image] but in the message box it is [image] PLEASE HELPPPP. I want the message box to display the same as the excel

@qaz1 check attached updated file is working qaz.xaml (6.2 KB)

Try this Datetime.ParseExact(yourdatevariable,“mm/dd/yyyy”,Globalization.CultureInfo.InvariantCulture) also refer this post it may help [image] Get date from an excel coulumn Help When i am extracting the date from an excel using row(column index).ToString Sometimes i am …

[image] NavneetPanpaliya: Datetime.ParseExact(yourdatevariable,“mm/dd/yyyy”,Globalization.CultureInfo.InvariantCulture) Hi thanks for the reply. Now i am reading it cell by cell. So it does not work.

I am reading cell by cell. So i think that URL does not apply to me… Sorry I am new to uipath

Use in message box dateValue.ToString(“dd/MM/yyyy”). Where dateValue - your datetime variable.

[image] Uemoe: .ToString(“dd/MM/yyyy” [image] still the same result…

@qaz1 Can you attach your workflow and excel file

qaz.xaml (6.2 KB) A2407.xlsx (9.1 KB)

Thank you very much. Actually I must input my excel to a third party system. So i was just trying it out at a message box first. So do you mind telling me what you did?

just changed data type from generic to date

Excel date format to message box

Help

indra (Indra) July 26, 2018, 3:02am 3

@qaz1 follow this url Excel split month and year from date - #20 by indra

Topic		Replies	Views
How to get exact date format ("MM/dd/yyyy") from the excel Activities excel , activities , question	9	1730	September 19, 2022
Read Date from Excel Help excel	4	2778	September 18, 2019
Format date in excel - dd.mm.yyyy StudioX studiox , question	12	152	August 22, 2024
Change date from excel Help	6	2574	July 30, 2018
Problem with a date from excel Help excel , studio	22	3972	May 3, 2020

Excel date format to message box

Related topics