Hi everyone! i need to convert a column of string(such as “25/08/20”,“15/08/20”,“17/07/20”) from a datatable to datetime formats without loop inside datatable. i have a problem with this assign: (From row In Compressed2 let dt= convert.ToDateTime(DateTime.ParseExact(row.Item(“Column2”).ToString,…

Hi @Pradyumna_TK , Here is the output. [image] You did well. only change in the dateformat . check it here. [image] [image] Sample here. Pradyumna.zip (77.8 KB) Regards Balamurugan.S

Convert datatable strings column to datetime

Help Studio

balupad14 (Balamurugan (BalaReva)) January 10, 2023, 1:21pm 12

Hi @Pradyumna_TK ,

Here is the output.

You did well. only change in the dateformat . check it here.

Sample here.

Pradyumna.zip (77.8 KB)

Regards
Balamurugan.S

Need to Change Date Format from string to Date

Topic		Replies	Views
Date Format Conversion in Linq Studio studio , question , activities_panel	6	4370	December 12, 2022
Transform datatable string column into data time format (DD-MM-YYYY) Studio question	26	7977	October 11, 2021
Converting String column in a DataTable to DateTime Studio datatable , uiautomation , activities , error	4	3753	October 6, 2020
DateTime.ParseExact the whole Column without looping Studio studio , question , activities_panel	13	1501	March 6, 2023
Change data column date format Academy Feedback datatable , activities , question , lp_developer_fnd	7	2386	January 25, 2021

Convert datatable strings column to datetime

Related topics