topic RE: Need to Sort a collection of Date time field in Product Forum

Need to Sort a collection of Date time field

PreetamSikdar1 — Thu, 20 Aug 2020 22:22:00 GMT

Hi

Created a collection which contains all the files and its created date as datetime.
Need to sort it with the latest or the oldest one.
How to do it?
I can write a C# code in the code stage but I am opting out that options.
and also I have another a solution to get all the date-time difference for each file.
But need other simple solution.
Sort Ascending true false not working on Created column.

------------------------------
Preetam
------------------------------

RE: Need to Sort a collection of Date time field

james.man — Fri, 21 Aug 2020 06:55:00 GMT

I was able to sort a collection of files based on the datetime, just by using the Utility - Collection Manipulation, Sort Collection action.

I've attached an example. Change the file path to suit your needs. The example will read all of the files belonging to a configurable folder path, and then sort them.

------------------------------
James Man
Professional Services
Blue Prism
Asia/Hong_Kong
------------------------------

RE: Need to Sort a collection of Date time field

PreetamSikdar1 — Fri, 21 Aug 2020 16:37:00 GMT

Thanks
it worked fine.

------------------------------
Preetam Sikdar
------------------------------