To filter the column with only dates and find the latest date from the column

Help Studio
, ,
1

for example -
Datatable1
Column1
12-21-22
02-22-21
12-21-22
02-22-21
ramkumar.pdf
excelupdatedfile.xlsx
marklist.pdf

2

Give a try at

AssignActivity
myMaxDateTime =

(From d In YourDataTableVar.AsEnumerable
Where DateTime.TryParseExact(d("Column1").toString.Trim, "MM-dd-yy", CultureInfo.InvariantCulture, DateTimeStyles.None, Nothing)
Let  x = DateTime.ParseExact(d("Column1").toString.Trim, "MM-dd-yy", CultureInfo.InvariantCulture)
Select v = x).Max(Function (x) x)
3

error : the sequence contains no elements in assign activity

4

Please provide a workflow

5

please share a screenshot from your implementation. Ensure that you have modified that LINQ and it is using the variable names from your implementation

6

Screenshot (30)
Screenshot (30)1920×1080 171 KB

7

Screenshot (31)
Screenshot (31)1920×1080 170 KB

check this

8

check your date format. the sample from above is maybe different - vs . seperator. Otherwise debug and check within the immediate panel some sample values of the datatable

9

Got it sorry it was seperated by (Dot.)
but one more scenario…
I wil provide a screenshot of webpage
from that i need to click the latest file if exist or the latest folder
Screenshot (32)

10

lets scope 1 topic = 1 case.
Initial you requested to filterout all non date values and find the latest date. When this case is solved then close the topic. Thanks

Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum

For the other question just open a new topic with a clear case description

11

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