Date changes after sorting the collection!

Jhalak

New Member
Hi Team,



I am trying to fetch the data from one application and put all the data in collection which includes Date time Column , then I was trying to append few of the columns which were required in another collection and sort the collection with the date difference.

Original Date as in the tool:

View attachment 1532936940252.png

I found that the date in the new appended collection change automatically (it is not the same date which was originally captured from the tool).

After sorting the date values changes automatically:

View attachment 1532936904998.png
Please assist .

Regards

Jhalak
 

VJR

Well-Known Member
Hi Jhalak,

The date in the sorted collection changes as per the timezone of your machine and its strange to know why BP has included that.
Refer below link:
http://www.rpaforum.net/threads/collection-sort-by-datetime-different-time.1834/post-6154
See if you can implement the solution mentioned in the above link.
If you have really large data then the other options would be something like to put the data in Excel, sort it there and then put it to the collection OR maybe tweak the code stage of the Sort collection action and explore the possibility of making changes there itself in the code OR maybe a totally new code stage to sort the collection datetime column correctly.
 
Top