Excel date format to message box

[qaz1]

In my excel, this is my date format:

but in the message box it is

PLEASE HELPPPP. I want the message box to display the same as the excel

[NavneetPanpaliya]

Try this Datetime.ParseExact(yourdatevariable,“mm/dd/yyyy”,Globalization.CultureInfo.InvariantCulture)
also refer this post it may help

Get date from an excel coulumn

When i am extracting the date from an excel using row(column index).ToString Sometimes i am getting date and time while sometimes only date.I need the date only.Pls help me![image]

[indra]

@qaz1 follow this url Excel split month and year from date

[qaz1]

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.

[qaz1]

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

Sorry I am new to uipath

[Uemoe]

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

[qaz1]

.ToString(“dd/MM/yyyy”

still the same result…

[indra]

@qaz1 Can you attach your workflow and excel file

[qaz1]

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

[indra]

@qaz1 check attached updated file is working

qaz.xaml (6.2 KB)

[qaz1]

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?

[indra]

just changed data type from generic to date

[qaz1]

Ohhh okay. Thank you so much!!!