Sort by date and time

Help
1

Hi guys,

How can filtrer data by date and time, which is in this format as a string “05/06/2019 15:34:02” ?

Thank you!

2

you can use filter datatable activity buddy

3

@mz3bel
you can mention the column name in the column name section and value you have in value section
For more info on filterdatatable activity
https://activities.uipath.com/docs/filter-data-table
Cheers

4

Cheers @Palaniyappan

This doesn’t help on my issue, how can i filter “05/06/2019 15:34:02” by date and also by time same time… ?

Thanks

5

can i have a sample excel
so that we could come up with a sample xaml
Cheers @mz3bel

6

Yes sure,

Here you go, A.xlsx (8.7 KB)

7

so what data you want to filter buddy @mz3bel

8

Hi @mz3bel,

You can use the sort data table for the specific date column you want

   DataView dv = ft.DefaultView;
   dv.Sort = "DateColumn desc";
   DataTable sortedDT = dv.ToTable();

TanQ,
Michael Udhaya

2 Likes
9

@Palaniyappan

Sort the data by date and time…

1 Like
10

Fine @mz3bel
but the topic was on filter
Alright :slight_smile:

11

Yea sorry, i meant sort, so i tough about filter :smiley:

12

so you want now to go with sort
@mz3bel

13

@Palaniyappan

Yes, please! My problem is that when i save this data on orcherstrator, it’s get randomly saved, not sorted.

So, i tough i would sort by date and time, before i save it on orchestrator.

Cheers mate

1 Like
14

@Michael_Udhaya

Thank you, but can you please give me more informations? on how to implement this on my code?

15

here you go with xaml
sort.zip (8.7 KB)
hope got resolved
Cheers @mz3bel

1 Like
16

Did that work buddy @mz3bel

17

@Palaniyappan

It works, but there’s a small issue, when i added a number to system “as system1 and system2”

The sort of data changed… it’s takes on considiration system1 as first data…

Which my issue, it should only focus on “title D” nothing more… PS : very sensitive data :smiley:

18

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