Sort by dates

Help Studio
, ,
1

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

1 Like
2

Hi

Welow to UiPath forum

Did we try with SORT DATATABLE activity

Or

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
4

image
its showing this error

5

You have missed the open bracket

@Prem_Kumar_S

6

I think you are missing bracket in starting of From

Thanks

7

yup got it thanks @Palaniyappan

1 Like
8

ya got it thanks @Shikhar_Tandon

9

Glad it got resolved @Prem_Kumar_S

1 Like
10

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

11

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