Convert Datatable column(string) to Date

ppr · October 20, 2020, 10:35am

@prateekjain1992
find starter help here:
DT_SortDate.xaml (7.0 KB)

for finding the correct format just check the content of the datatable while debugging (Excel visual value is not mandatory the same within the datatable after a read range)

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum

Demo on this format:

Topic		Replies	Views
Sort datatable ascending Activities excel , activities , studio	4	1293	September 28, 2021
Convert String to Datetime and sort a datatable Activities datatable , uiautomation , date , datetime	8	1328	October 27, 2023
Sort by Date from data table Academy Feedback datatable , activities , question	5	6333	March 6, 2020
Sort datatable by column with date format "dd-mm-yyyy" Help	11	11047	September 13, 2019
Converting all values in a column to Date format Activities excel , activities , question	6	3258	September 1, 2022

Convert Datatable column(string) to Date

Related topics