How to extract oldest date and latest date in datatable

Help Studio
, ,
1

Hi there,

I have a datatable extracted from a csv file.
The datatable has multiple columns and one of them is a date column which is a string type.
I could read range from csv file, but cannot extract oldest (min) and latest (max).

I tried this below image referencing from this post: Select(find) max date from datatable .

Dt.AsEnumerable().Max(Function (drRows) DateTime.Parse(drRows.Item(8).ToString)).ToString

image
image738×209 22.9 KB

However i got an error:
image

How do I get this correctly??

2

Exception occurs if the date string is within a form that is not parseable by the DateTime.Parse method.

I that case a quick analysis on data from the datatable will help

  • set a break point on relevant location
  • debug the bot and get pause
  • open immediate panel
  • use following statement: dt.Rows(0)(8).toString

please share the output with us, so we can further help. Also check the CSV file that all dates are consistent in the format and not empty

3

Hi
Thank you for your reply.

I have never used immediate panel and am not sure if i did it right. but here’s the output.

image
image958×487 22.6 KB

I checked the csv file and the dates are consistent since it was downloaded file.

4

Perfect you have done correctly

175 is not a date string. Kindly note column index is 0 based. Maybe the date is within another column. Can you check this please? Thanks

5

You are right.
I put a wrong column index. :woman_facepalming:

I spent a lot time to solve this, and didnt even notice that.

Thank you so much for your time.

6

Perfect. Issue is identified. This can happen to all of us.
Just do your final testing. Let us know your further open questions. Once it is working please mark the solving post as solution. So others can benefit from it.

Thanks
Peter

1 Like
7

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