CertificationExam_filterDate

[imamSamudi]

Hello Everyone, I’m a beginner in UI Path. Can you help me solve this problem, please.
i want to filter the records where Date is older than ‘1st of December 2017’.
This is my condition. But this is doesnt work.

row(“Status”).Equals(“Open”) And row(“Description”).Equals(“Verify Account Position”) AND ReferenceDate.CompareTo(DateTime.ParseExact(row(“Date”).ToString, “yyyy-MM-dd”, CultureInfo.InvariantCulture)) < 2017-12-01

Sorry i cant upload my attachment because i am new user.

[kadiravan_kalidoss (Kadiravan K)]

@imamSamudi

Date is older than ‘1st of December 2017’ .

Hi @imamSamudi,

Try like this in assign statement,

ExtractDataTable.Select(“[Status]=‘Open’ AND [Type]=‘WI3’ AND [Date]<‘2017-12-01’”).CopyToDataTable

Modify as per your condition.

Thanks!

[supermanPunch (Arpan)]

@imamSamudi We may Need to Convert the Date From String into Date Variabe and then compare

[imamSamudi]

sorry sir, new error has appear " ‘Select’ is not a member of ‘System.Data.DataRow’ ".

[kadiravan_kalidoss (Kadiravan K)]

@kadiravan_kalidoss

ExtractDataTable.Select(“[Status]=‘Open’ AND [Type]=‘WI3’ AND [Date]<‘2017-12-01’”).CopyToDataTable

Dont use select query inside for each row activity…

After datascraping, put one Assign activity…!

outputDatatable=ExtractDataTable.Select(“[Status]=‘Open’ AND [Type]=‘WI3’ AND [Date]<‘2017-12-01’”).CopyToDataTable

Try this…!

Thanks!