Sort by date and time

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!

you can use filter datatable activity buddy

@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


Cheers

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

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

Yes sure,

Here you go, A.xlsx (8.7 KB)

so what data you want to filter buddy @mz3bel

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

@Palaniyappan

Sort the data by date and time…

1 Like

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

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

so you want now to go with sort
@mz3bel

@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

@Michael_Udhaya

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

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

1 Like

Did that work buddy @mz3bel

@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:

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