Read Date from Excel

excel

#1

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


#2

Do you have a sample Excel file to test?


#3

@souravmaz follow below link

Excel date format to message box


#4

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: