Convert DateTime(O/p from Datatable) value to Short date

[msalesforce777]

Hi,
I have a datatable, i have fetched Datetime from column,i need to convert datetime(string) value to shortdate.

[kalyanDev]

use .Toshartdatestring instead of .tostring

[KarthikByggari]

dateformat should be String data type (because of your expression returns string)

If you want to convert the string to datetime, then

dateformat = Convert.ToDateTime(string)

Regards,
Karthik Byggari

[Vashisht (Vashisht Devasani)]

Hi @msalesforce777,

Welcome to the community…

Try to use like this it works fine for me…

Cheers.
Vashisht.

[msalesforce777]

Thanks alot

[msalesforce777]

This works perfectly

[balupad14 (Balamurugan)]

Here is an activity called DateTime parse to data table that to convert the data table column to DateTime.

UiPath Marketplace - BalaReva Easy Data Table Activities

Dear all, I have developed a new activity called “DateTime ParseTo Datatable”. Convert the object/string data type to dateTime datatype in Data. And also has the solution Solution to manage the excel DateTime in DataTable. [image] Sample :DateConversion.zip (35.5 KB) [UiPath convert column datatype to datetime in DataTable] Thank you Balamurugan.S

Regards
Balamurugan.S