Get Exact Date format in Excel

Hi I wanted to get exact date format from my excel but it gives me incorrect data.
I already Check the “Preserve format” in read range activity.

Here is the output.

Here is my date format in excel
image

Any help?
Thank you in advance

Hi

Did this thread help us on this issue

@Vincent_Nuestro

Hi sir, already tried this but its not working.

Fine
Go to Design tab → Manage Pacakges → Project Dependencies and there upgrade UiPath.Excel.Activities package and give a try @Vincent_Nuestro

Hi Sir,
heres the output.
image

it gives me the date and year. but not the months

1 Like

Fine is the column set to text in Excel and preserve format property is enabled in studio activity @Vincent_Nuestro

i have a custom date format (mmmm dd, yyyy)

image

and Yes the preserve format is properly enabled

Pls change the format to text instead of custom and give a try @Vincent_Nuestro

you have to use “Excel application scope” + “read range” (with preserve format) and it will work, output will be same as your excel e.g. “August 16 2021”
image

dont use the other read range (the output will be “00 16 2021”)
image

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