Data table doubt

Help
1

Hi all, i have doubt how to use conditions on for each row!

image
image921×522 11.7 KB

i want to get the date from work item page as less than 01/01/2018
so how can i write the code inside IF
've tried like row(“Type”).Equals(“WI4”) and row(“Status”).Equals(“Open”) and row(“Date”)>=2018-01-02

but its wrong!!
please make me correct how should i get the date from the DT.

Thanks

2

Instead of IF condition, please use Data Table Filter to select the matching rows or use DataTable.Select method to filter the rows.

https://activities.uipath.com/docs/filter-data-table

If you still want to use the conditional statement, then

convert both dates into date format

DateTime dt1 =  DateTime.ParseExact(row("Date").ToString,"YOURDATEFORMAT", System.Globalization.CultureInfo.InvariantCulture)
DateTime dt2 = new DateTime(2018,04,30);

Condition:

row("Type").ToString == "WI4" AND row("Status").ToString == "Open" AND dt1.Date >= dt2.Date

Regards,
Karthik Byggari

3

Hi @naveen19,

Use .ToString()

Try below code

row("Type").Tostring()="WI4" and row("Status").Tostring()="Open" and row("Date").ToString()>="2018-01-02"

Regards,
Arivu :slight_smile:

2 Likes
4

thanks its working

1 Like
5

thanks its working:)

6

Excercise.zip (2.3 MB)

hi bro only 1st page getting read and getting appending on Excel.
but need to filter from all the pages of DT right please help me to solve this

7

hi bro only 1st page getting read and getting appending on Excel.
but need to filter from all the pages of DT right please help me to solve this.
Excercise.zip (2.3 MB)

8

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