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
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
Try this Datetime.ParseExact(yourdatevariable,“mm/dd/yyyy”,Globalization.CultureInfo.InvariantCulture)
also refer this post it may help
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.
still the same result…
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
Ohhh okay. Thank you so much!!!