Filter records by date in DataTable

Help Studio
1

Hi All,

Need help with below:

  1. using data scraping, I have imported data to a DataTable.
  2. SEcond column of datatable is of date in application(04/28/2020 18:53:00) and my system time is (04/28/2020 18:53:00), I have changed application column date format to that of System.
  3. I am trying to filter records using Index( like providing index number 5-for 6th column).
  4. Now My requirement is to add one more condition in Filter Records with condition ‘start time’ (Aplication column name) and index no in DataTable is ‘1’.
    EX: Start Time<=Now() or Start Time<=Current time/Systime

Please advice

Regards,
Satish Chaladi
8147943248

2

Hello,

Try usign “Filter Datatable” activity where you get Filter Wizard to implement all the conditions for filtering data

3

Hi,

I am using it, but failing to filter data using start Data<=Now() condition.

image
image1366×768 92.2 KB

image
image1366×768 169 KB

4

I want to filter records which are created on or before Current time and write to CSV.

5

Write the Column Name in the Column Fields and you cannot directly use Now(),
you have to use Date.Now()

But Date.Now will return date with current time with seconds. Seconds will never match your data scraping table.
You will have to work only on date part dd/MM/yyyy

Hope this helps your case.

Cheers

6

I Want time also, to filter data, seconds we can leave. but hours and minutes are required… Thats the main requirement here for us.

7

image
image896×500 48.3 KB

Use Compare Dates activity from this pacakage

OR use Short date time for comparison