Read Date from Excel

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 details.

Thanks,
Maz

Do you have a sample Excel file to test?

@souravmaz follow below link

Excel date format to message box - #10 by indra

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:

1 Like

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