Sort by dates

merge.xlsx (10.4 KB)
helpme sort this excel sheet with respect to month of the date column in ascending

1 Like


Welow to UiPath forum

Did we try with SORT DATATABLE activity


If that doesn’t work use read range and get the datatable as dt and use a assign activity like this

dt = (From row In dt Order By DateTime.ParseExact(row.Item(“Date”).ToString.SubString(0,10), “dd.MM.yyyy”,
System.Globalization.CultureInfo.InvariantCulture) Descending Select row).CopyToDataTable

Cheers @Prem_Kumar_S

1 Like

its showing this error

You have missed the open bracket


I think you are missing bracket in starting of From


yup got it thanks @Palaniyappan

1 Like

ya got it thanks @Shikhar_Tandon

Glad it got resolved @Prem_Kumar_S

1 Like

and i tried general sort activity why didnt it work??

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.