After read range activity, I am getting date as this type ‘44244’ which originally should be ‘2/17/2021’, which generally fixes by doing Format Cells in Excel to Date format but how can we achieve this using Uipath. Can anyone help with this? Thanks in advance.

Hi @shandilya.suthar15 Try this: DateTime.FromOADate(Convert.ToDouble(row(“yourcolumnname”).ToString)).ToString(“MM/dd/yyyy”)

Convert string format date to the Date format

prasath17 (Guru) March 3, 2021, 1:55pm 4

@shandilya.suthar15 …Oh okay…In that case, can you please try the read range for workbook …

Also check this post…

How to properly convert Date from excel to String?

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	388	November 4, 2023
Any method for keeping the date as it is? Studio studio , question , activities_panel	18	332	July 28, 2023
Date Format issue while executing Help	9	1228	October 30, 2019
Date Format in Excel Reading Activity Help studio	6	9150	December 6, 2022
Date conversion from excel value saved as number Help excel , activities , question	5	3352	February 10, 2021