Getting date format changed in immediate pannel

Help Studio
, ,
1

image

if you will see the above ss ,i am reading one excel with read range with above mentioned date.
but after reading this excel sheet and i if i print the value in log or immediate pannel, i am getting date format changed, for ref attaching ss below:

image

2

@ankur_kaushik2

Generally When you read from excel the format might change

Please use Preserve formatting option if using classic

image
image412×527 19.1 KB

else use display values option instead of raw values in use excel scope to get the date is exact same format
image

cheers

3

still getting reverse

image

image

4

Hi,

It’s because your date date exists as Date type in the worksheet and UiPath read it as DateTime type then show it as invariant culture. Do you have any problem? if you write it to your sheet it will be shown as your locale like dd-MM-yyyy style. Or we can get dd-MM-yyyy style date string using DateTime.Parse(row(“column”).ToString).ToString(“dd-MM-yyyy”).

Regards,

1 Like
5

if it is like this then please look this output
image

and here is excel data
image

first one issue date is correct and bill date is correct others all in reverse why ?even its a same input excel.

only difference i can see is 13-03-2023 is little bit upside in cell.

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.