Extract data table: Current date -10days

Help
1

How to write a statement for extracting values in a datatable where it meets current date-10days in one column

Assign: ExtractDataTable. Select(“[Supp Status]= ‘LIVE’ AND [Send Date]=‘DateTime.Now.AddDay(-10).Tostring(mm/dd/yyyy)’”).CopyToDataTable

It is Not working and returning no rows

1 Like
2

@sonesh.bansal you can give like this buddy Extractdatatable.select("date<‘date to till you want to filter’ ").copytodatatable

3

Hi @venkatmalla6

I don’t want to give hard coded values by specifying particular date. It should filter all the values with a condition of “Current date-10days”.

4

Hi @sonesh.bans

Use now.tostring.Adddays(-10).to string

Use this in condition

Thanks
Ashwin.S

5

@sonesh.bansal ok fine,even i don’t have idea on that let’s see if any our forum members will find it. i think @lakshman @Palaniyappan can clear our query.

1 Like
6

No not working:

I want to filter datatable with multiple rows with following conditions in two columns where

  1. Coloumn named: Supp Status should be “LIVE”
    It is working as it is a string
  2. Column named “Send Date” should filter all the dates which are current date-10 days. It is a date column and I think we should covert this column to date first.
7

Fine
Kindly try with this buddy
ExtractDataTable. Select(“[Supp Status]= ‘LIVE’ AND [Send Date]=#” + DateTime.Now.AddDay(-10).Tostring() + "# ").CopyToDataTable()

8

@sonesh.bansal

Try these steps:

In Assign, String date = DateTime.Now.AddDays(-10).ToString(“MM/dd/yyyy”)

ExtractDataTable.Select(“[Supp Status]= ‘LIVE’ AND [Send Date]='”+date+“'”).CopyToDataTable

For your reference, please find the sample example.

Main.xaml (7.5 KB)

10

@lakshman

Check this file:

Main.xaml (21.5 KB)

1 Like
11

@sonesh.bansal

What error are you getting ?

Have you checked my workflow or not ?

12

@lakshman

Yeah I have checked, you have build data table and assigned “Name” and given a desired value by declaring a variable.
My date column name from the scraped data is “Send Date” which is not a valid variable name.

Error from my workflow above: No rows in source data
I have the rows count of 90 when in ExtractDataTable.

FinItems is working for all columns except Send Date for which I am not able to filter

13

@sonesh.bansal

If possible, Could you please show me sample input data you are processing.

14

@lakshman

Sorry I cant share whole date, its confidential.

But For example:

Send Date
05/31/2019
06/07/2019
06/12/2019

06/12/2019

Column also contains null values

15

@sonesh.bansal

Please check below example for your reference.

Main.xaml (7.6 KB)

16

@lakshman

Please modify your data table in your example and try with the following three columns:

Supp Status Send Date Status

LIVE 05/31/2019 Ready
LIVE 06/07/2019 Ready
LIVE 06/12/2019 Ready
LIVE 06/12/2019 Ready
LIVE Ready
LIVE 06/18/2019 Ready
SENT 06/18/2019 Ready

Could you please try with the above data table without changing the column names and output should be Supp Status= LIVE and Send Date= current date-10days

17

@sonesh.bansal

Please check below file and just changed the dates from above input data to print output result.

Main.xaml (8.1 KB)

18

@lakshman

Please run your workflow, it says no source data rows. That is my exact problem, now you can understand

19

@sonesh.bansal

It’s working fine. Today 26th June 2019 right.

If the input data contains 16th June 2019 then it will give output else it will give no source data rows.

20

@lakshman

How about outputting all dates( data rows) which are less than 10 days

21

@lakshman

I got it. Thanks much for your help

1 Like