Count date feature and past values from today date

Help Activities
, ,
1

hi,
i have an excel file in that column date- i want to count previous date vales from today date , and feature date vales counts

trackid Date of Completion
32 02/09/25
4 01/09/25
5 11/09/25
7 09/09/25
8 16-10-2025
9 28-10-2025
1 26-09-2025
2 30-09-2025
4 01/09/25
12 25-10-2025
11 27-10-2025
10 04/10/25

2

Hi @anand_kumar4

today = DateTime.Today
pastCount = dtData.AsEnumerable().Count(Function(r) DateTime.Parse(r(“Date of Completion”).ToString) < today)
futureCount = dtData.AsEnumerable().Count(Function(r) DateTime.Parse(r(“Date of Completion”).ToString) > today)

Try this Happy Automation

3

hi @prashant1603765 i have tried but the date format showing error below
Assign: String ‘16-10-2025’ was not recognized as a valid DateTime.

please find attached excel

Book1.xlsx (11.0 KB)

4

@anand_kumar4

please try this

pastCount = dtData.AsEnumerable().Count(Function(r) DateTime.ParseExact(r("Date of Completion").ToString,"dd-MM-yyyy",System.Globalization.Cultureinfo.InvariantCulture) < Now)
futureCount = dtData.AsEnumerable().Count(Function(r) DateTime.ParseExact(r("Date of Completion").ToString,"dd-MM-yyyy",System.Globalization.Cultureinfo.InvariantCulture) > Now)

cheers

5

@anand_kumar4

formats = {“dd/MM/yy”, “dd-MM-yyyy”}
today = DateTime.Today

pastCount = dtData.AsEnumerable().Count(Function(r)
DateTime.TryParseExact(r(“Date of Completion”).ToString.Trim, formats, Globalization.CultureInfo.InvariantCulture, Globalization.DateTimeStyles.None, Nothing) AndAlso
DateTime.ParseExact(r(“Date of Completion”).ToString.Trim, formats, Globalization.CultureInfo.InvariantCulture, Globalization.DateTimeStyles.None) < today)

futureCount = dtData.AsEnumerable().Count(Function(r)
DateTime.TryParseExact(r(“Date of Completion”).ToString.Trim, formats, Globalization.CultureInfo.InvariantCulture, Globalization.DateTimeStyles.None, Nothing) AndAlso
DateTime.ParseExact(r(“Date of Completion”).ToString.Trim, formats, Globalization.CultureInfo.InvariantCulture, Globalization.DateTimeStyles.None) > today)

Try this.
If you found helpful please mark as a solution. Thanks
Happy Automation with UiPath