I wanted to convert column value from date time to string

Help Studio
, ,
1

Can anyone tell me how to convert date time column into string type in datatable using LINQ query?

Thanks in advance

2

@Nisha_K21

3

Hi @Nisha_K21

The image shows a UiPath workflow using the "Read Range Workbook," "Invoke Code," and "Write Range Workbook" activities to process data in an Excel file. (Captioned by AI)
The image shows a UiPath workflow using the "Read Range Workbook," "Invoke Code," and "Write Range Workbook" activities to process data in an Excel file. (Captioned by AI)545×586 18.1 KB

A dialog box labeled "Invoked code arguments" shows a DataTable argument named "dt" with In/Out direction. (Captioned by AI)
A dialog box labeled "Invoked code arguments" shows a DataTable argument named "dt" with In/Out direction. (Captioned by AI)881×263 10.5 KB

dt.AsEnumerable().ToList().ForEach(Sub(row) row("DateColumn") = Convert.ToDateTime(row("DateColumn")).ToString("dd-MM-yyyy"))

Regards,

4

Is there any other way to do this? I didn’t find useful this.

5

@Nisha_K21

Can you try with Format Cells activity

Regards,

6

Hi @lrtetala , I didn’t get could you please elaborate

7

@Nisha_K21

Create a new column of string tupe and then use assign

Dt.Columns("New col").Expression = Convert([OldColumnName],System.String)

Cheers