Date Time format to Date format conversion for whole data in the data table column

[Gopi_Arumugam]

Hi,

I have a data table which has a column(Ex-Date of Joining) with the data like 07-04-2019 19:30:00(dd-MM-yyyy hh:mm:ss). I want to changes this 07-04-2019 19:30:00 format to 07-04-2019 (dd-MM-yyyy) for a whole column in the data table. I don’t want to use for each row activity because it contains 4000+ records. it takes more time. i want to do this efficiently. please help me to resolve this issue.

Thanks!

[Manish540 (Manish Shettigar)]

Check this below link, @Gopi_Arumugam

Linq - Update Values in Datatable

@noam 1.update new value for all rows in a specific column - for example update all the values in column number 4 (no matter what was the old value) to new value You can play on provided xaml with following (Col 3 is updated with NewValue String) (From d In dtData.AsEnumerable Let ra= New Object(){d(0),d(1),“NewValue”} Select dtResult.Rows.Add(ra)).CopyToDataTable for second request have a look here: Reset_StatusCol_MultiContains_KwordList.xaml (8.0 KB)

Hope this may help you

[NIVED_NAMBIAR (NIVED N)]

Hi @Gopi_Arumugam

For doing it faster u can try this way

1. Use read range with preserve format option ticked and store the results in datatable dt1

2. Now use the below in invoke code with language as vb.net with argument as in/out for dt1

dt1.AsEnumerable().ToList(Sub(row) row(“Ex-Date of Joining”)= Datetime.ParseExact(row(“Ex-Date of Joining”).ToString,“dd-MM-yyyy hh:mm:ss”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd-MM-yyyy”))

Try this

Mark it as solution if it resolves ur query

Regards

Nived N

Happy Automation

[Gopi_Arumugam]

It’s not working…any other solutions pls!

[NIVED_NAMBIAR (NIVED N)]

what error u are getting buddy?

I think I had put wrong response in my earlier answer

I had corrected it

Please check

[Gopi_Arumugam]

[NIVED_NAMBIAR (NIVED N)]

Can u show the invoke code part

Coding and argument passing part

[Gopi_Arumugam]

In the invoke code, have given in the single line… for taking screenshot split into two lines

[Gopi_Arumugam]

can you please share the workflow to convert the date format for a whole data table column using a column in excel like this.

[NIVED_NAMBIAR (NIVED N)]

Sure please wait …