How to filter date column in excel datatable using filter datatable activity

Help
1

Hi,
i need to filter date column in excel using filter datatable activity.which operation should i use if it should start from specific date.

Please guide if anyone knows.

Regards,
Supriya.

2

Please find the workflow here -

3

thanks but my doubt is cant we do with filter datatable activity?

1 Like
4

Yes. You can filter the dates using the Filter DataTable Activity.

Make sure that, the column in the datatable should be DateTime data type.

Create a DateTime variable with a date and use the same variable in the Value field (condition).

For creating date -
dtDate = new DateTime(2019, 01, 03)

1 Like
5

in excel i have column as date with values 2018-01-01.Now i want to filter those dates starting from 2018-01-01. how can i do this

6

Create a datetime variable, dateFilter = new DateTime(2018,01,01)

In filter data table activity,
In the column field enter column name, select condition, and in the value field enter “dateFilter”

7

i tried what u said.I am getting blank excel

8

@SUPRIYA123 Refer this Post

9

Use assign activity & add into To:variable1(ArrayOfDataRow)=Value:Refer below image

Capture

10

Yes… you can refer this also… its work

11

if we give like that in assign activity,it is showing error as datarow cannot be converted to datatable

12

@SUPRIYA123 Is it possible to attach sample excel file and can you specify from which date you needs to filter

13

ok.I want from 2018-01-01
filtered workitems.xlsx (8.8 KB)

14

@SUPRIYA123 Check this xaml file Main.xaml (9.9 KB)

15

ok.thanks

1 Like
16

DataRow.CopyToDataTable
refer below image

Capture
Capture1250×565 27.4 KB

2 Likes
17

thanks

18

:+1:

19

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