I have Datatable where column3 (FacilityTime) is Datetime. I want this column to be changed to “Object”. so that i can insert null values from FacilityTIme column to DB and also i have to format the datetime 10/12/2009 11:09:12 PM to required format while inserting into DB. I am recieving below err…

I might require something like this. [image] Convert datatable strings column to datetime Studio @Angelo_Savino In General the LINQ Syntax should/could look like following (From row In Compressed2.AsEnumerable Let dt= DateTime.ParseExact(row.Item(“Column2”).ToString,“dd…

Hello @Satish_Ch Have you tried keeping the format of the column as Text? If not give it a try.

I tried nothing worked except changing column to object type.I did it using build datatable and for loop but now iam using linq as for loop taking too much time for 3000 rows.

Hi @Satish_Ch , Can this field be datetime in your database? Can you check your table by coming to the design section? If your db table is in date format, you will need to convert your latest data here. Also In the first datatable you build, you need to make the relevant column type datetime. Rega…

Yes it is Datetime only in Database. its accepting only particular format 12/12/1999 11:09:09 PM something like this, and i have null values also in my column . so i want to convert my datetime into object so that null values also can be stored and convert back the remaing values to datetime using d…

Hey! One small suggestion! If you’re using build data table we have an option called allow null values. when we check this option this will allow us to add the null values also… Convert the string to datetime try like this Cdate(Input).ToString("dd-MM-yyyy hh:mm:tt") Regards, NaNi

i already did with build datatable and i am able to find the solution as well but as its taking i want to do it using linq.

Hi @Satish_Ch , Could you let us know How are you reading the TrailerData datatable? Is it being read by Read Range Activity ? If that is the case, then the columns should normally be of Object type. You can use the Query below to check the Datatype of the Columns in Debug Panel. DT.Columns.Cast…

Okay I am using read range only.So its object type.Then i just have to convert my column values to datetime desired format. May i know how to do it using linq.

@Satish_Ch , Could you try using the below Snippet component and check if you are able to achieve it ? Novigo Solutions - Change Column Type to DateTime - RPA Component | UiPath... This workflow converts the datatype of a specified column from String to DateTime …

I cant use components in marketplace.

Prepare/Modify Datatable as Datetime column has null values

Help Studio

Satish_Ch (Satish Ch) June 29, 2022, 9:55am 6

I might require something like this.

Can someone let me how to convert column to object type from datetime and after that convert values back to datetime.
@ppr @Yoichi

Topic		Replies	Views
Date Format Convert using linq Studio studio , question , activities-panel	5	1131	October 6, 2023
Date Format Conversion in Linq Studio activities , studio , question , system , activities-panel	6	4635	December 12, 2022
Convert datatable strings column to datetime Studio datatable , activities , studio , string , system	11	15751	January 11, 2023
Filter DataTable using Linq Studio excel , activities , studio , question , system , workflow-diff	13	5141	June 29, 2022
Change the column type from a data table with Linq Studio activities , studio , question , system , activities-panel	5	521	July 2, 2024

Prepare/Modify Datatable as Datetime column has null values

Related topics