[image] Getting this Error Not Sure Why The column which I am retrieving the data from is a date column. How do I solve this ?

Hi @Ishan_Shelke1 , Maybe you are trying to Assign a DateTime value to a String variable. That is the Output variable of the Get Row Item Activity. Try by changing the Output variable type of the Get Row Item Activity to UiPath.Core.GenericValue

Try this DateTime.ParseExact(pdate,“yyyy-MM-dd” (date format in excel),System.Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”)(date format in which you need the output to be)

Hi, This error means that you got a format error while assigning the value you received. It will be fixed when you convert it in the correct format. You can get more detailed support about date format by following the link. [image] Error about datetime? Activities @poorn…

Get Row Item Datetime Error

Help Robot

ppr (Peter Preuss) May 19, 2022, 8:47am 4

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum

Topic		Replies	Views
Error when Converting String to Date format in data table Studio studio , question , activities_panel	3	585	June 10, 2023
DateTime Error Robot robot , question	6	673	August 9, 2022
Date showing in excel and in the data table are different and needs conversion Activities datatable , uiautomation , activities , error	4	1810	March 24, 2021
Error message: Assign: String was not recognized as a valid DateTime Studio studio , question , activities_panel	10	1231	April 4, 2023
Assign Date Column Activities uiautomation , studio , question	4	722	March 1, 2021

Get Row Item Datetime Error

Related topics