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

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 …

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

[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, 5:50am 10

@qaz1 check attached updated file is working

qaz.xaml (6.2 KB)

Read Date from Excel

Change date from excel

(URGENT) Different date format to a standard date format

Topic		Replies	Views
How to get exact date format ("MM/dd/yyyy") from the excel Activities excel , activities , question	9	1773	September 19, 2022
Read Date from Excel Help excel	4	2816	September 18, 2019
Format date in excel - dd.mm.yyyy StudioX studiox , question	12	231	August 22, 2024
Change date from excel Help	6	2602	July 30, 2018
Problem with a date from excel Help excel , studio	21	4046	April 30, 2020

Excel date format to message box

Related topics