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