Get Exact Date format in Excel

[Vincent_Nuestro]

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

Any help?
Thank you in advance

[Palaniyappan (Palaniyappan P)]

Hi

Did this thread help us on this issue

Uipath change the date format when i read a excel

When i use the write range activity the date format change from the original [date] How can i make this doesnt happen?

@Vincent_Nuestro

[Vincent_Nuestro]

Hi sir, already tried this but its not working.

[Palaniyappan (Palaniyappan P)]

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

[Vincent_Nuestro]

Hi Sir,
heres the output.

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

[Palaniyappan (Palaniyappan P)]

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

[Vincent_Nuestro]

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

[Vincent_Nuestro]

and Yes the preserve format is properly enabled

[Vincent_Nuestro]

[Palaniyappan (Palaniyappan P)]

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

[jack.chan]

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”

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