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. [image] Here is my date format in excel [image] Any help? Thank you in advance

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]

Get Exact Date format in Excel

Help Studio

Palaniyappan (Palaniyappan P ) July 21, 2021, 7:19am 2

Did this thread help us on this issue

@Vincent_Nuestro

Topic		Replies	Views
Uipath reads the data from excel in MM/dd/yyyy Format, but the value is in dd/MM/yyyy Studio studio , question , activities_panel	5	455	November 4, 2023
Excel and workbook read range behaving differently during Read Range Help activities	7	1647	August 25, 2019
How to get the date in excel in date time format Activities excel	3	634	April 23, 2021
Copying DATE from excel to UiPath Studio Studio excel , activities , studio	10	499	March 9, 2024
Format date in excel Activities excel , activities , question	9	1306	June 4, 2021

Get Exact Date format in Excel

Related topics