"Sort Data Table" activity not sorting

[Dammy]

I added the “Sort data table” activity to sort dates in descending order. It has recently stopped sorting the “date” column in my excel sheet. The format of the cells is “date”. Does anyone know why it will not sort the date column anymore?

[ppr (Peter Preuss)]

currently we cannot refer to the details or derive it from the description

the values visually presented in EXCEL are not mandatory stored in the same way / format within the datatable

in such cases we would inspect the datatable

Understanding the 6 Debugging Panels of UiPath in the easiest way possible!

One of the very important topic of UiPath in Debugging is understanding the different debugging panels and when to use which panel during debugging. In this video, we will understand all the 6 debugging panels of UiPath in the easiest way possible. Video Link: Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - YouTube

maybe also analyze on formats and parsing options

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues

This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in hurry: Example Assignment Following Excel data will be processed and the corresponding Quarter is to calculate for the particular task date Input data: [input_raw] Quarter Calculation Quarter = CInt(Math.Ceiling(YourDateTimeVar.Month / 3 )) Initial Implementation [initial_flow_raw] tmpTaskDate = DateTime.ParseExact(row("Date").toString.Trim, "dd.MM.yyyy", Culture…

and give a try on sorting with a LINQ

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operator [HowTo] Overview Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start…

[Yogeesh_G]

Hi

check The format of the date column is correct or not . Make sure that the date column is formatted as a date. You can check this by right-clicking on the column header and selecting “Format Cells”. If the format is not set to “Date”, then change it to “Date” and try sorting again.

Thank you

[Dammy]

Thank you, for responding! it’s been resolved. It is working now. I wanted it to “Ascend” not “Descend”. Please disregard my question.