I have a column in input excel in (dd/MM/yyyy) format. when I’m reading this in UiPath read range activity and printing the respective data in message box using .ToString . I’m getting it as (MM/dd/yyyy) format. why? Let me know your valuable answers and also ask me if you need the qs in more detail…

Do you have a sample Excel file to test?

I have resolved the issue. Looks like I was converting it first that’s why by default it is changing the format. Taken care. thanks for your time. :slight_smile:

I have a query. I want dates which are present in one row of an excel to be updated column wise .

Read Date from Excel

Help

indra (Indra) August 24, 2018, 1:56am 3

@souravmaz follow below link

Excel date format to message box - #10 by indra

Topic		Replies	Views
Date and month interchanged while reading from excel Studio	6	2456	November 11, 2022
Uipath reads the data from excel in MM/dd/yyyy Format, but the value is in dd/MM/yyyy Studio studio , question , activities_panel	4	523	November 4, 2023
Date Format issue while executing Help	9	1468	October 30, 2019
Date Format in Excel Reading Activity Help studio	6	9384	December 6, 2022
Want date format from excel in a desired type of date format Studio studio , question , immediate_panel	23	1162	May 29, 2023

Read Date from Excel

Related topics