Different Dates

Help Studio
, ,
1

You have 10 different dates, it consists of past & future dates.
Bot should check how many old dates & how many new dates

Forum Engagement Daily Reports
2

Hi @Shravan_Pintu

oldDatesCount = dtDates.AsEnumerable().Count(Function(row) CDate(row("Date")) < DateTime.Now)


newDatesCount = dtDates.AsEnumerable().Count(Function(row) CDate(row("Date")) >= DateTime.Now)

Regards,

1 Like
3

How to give 10 different dates using excel?

4

@Shravan_Pintu

This image shows a UiPath sequence that reads a workbook, assigns the count of enumerable items from a DataTable to two variables, and displays these counts in two message boxes. (Captioned by AI)
This image shows a UiPath sequence that reads a workbook, assigns the count of enumerable items from a DataTable to two variables, and displays these counts in two message boxes. (Captioned by AI)818Γ—698 36.2 KB

Input:

image

Output:

image

1 Like
Forum Engagement Daily Reports
5

The image shows a UiPath workflow with an error message indicating that an implicit conversion from 'Integer' to 'String' is disallowed due to Option Strict On, making the selected value incompatible with the property type. (Captioned by AI)
The image shows a UiPath workflow with an error message indicating that an implicit conversion from 'Integer' to 'String' is disallowed due to Option Strict On, making the selected value incompatible with the property type. (Captioned by AI)796Γ—434 19.2 KB

dtDates.AsEnumerable().Count(Function(row) CDate(row(β€œDate” ))<DateTime.Now)

6

@Shravan_Pintu

Change OldDateCounts variable datatype to Int32

1 Like
7

in excel the format is DD/MM/YYYY?

8

@Shravan_Pintu

Try this

oldDatesCount = dtDates.AsEnumerable().Count(Function(row) DateTime.ParseExact(row("Date").ToString(), "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) < DateTime.Now)
9

Thank you very much

got the solution

in excel using this formats helped MM/DD/YYYY

1 Like
10

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