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.

Convert string format date to the Date format

pravin_calvin (pravin kumar) March 3, 2021, 2:19pm 5

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

1 Like

Reading dates in excel return random numbers not the date

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