Date is older than '1st of December 2017' (discard newer records);

For each page:

  • Filter the records where Status is ‘Open’ ;
  • Filter the records where Type is ‘WI3’ ;
  • Filter the records where Date is older than ‘1st of December 2017’ (discard newer records);

i use like this but is not working
row is my forreach
row(“Type”).Equals(“WI3”) And row(“Status”).Equals(“Open”) And (row.Select (“Date<‘2017-12-01’”))
early i tery
using CINT(row(“WIID”)) > 300000
but i don’t know no about date

please help me for date

are you working with a dataTable? If so, use the filter dataTable activity instead of a for each.

about the date:

You will find the solutions in those 2 links. :slight_smile:

Hi All,

Referring to this same topic, how do I include the “date > ‘2018/01/01’” portion in the expression below? I’m not using ‘For Each Row’ activity but rather ‘xxx.Select()’ method.
image