Comparing Dates in Data Table

Help Studio
, ,
1

Hi All,

I am trying to extract max value of date from Data Table and then comparing with the current row row date. If both the dates are equal then I am clicking the max date. Even though after comparing I am getting the dates equal(output using write line) but in my case its going to else part saying dates are not matched . I have tried using Trim at the ned of both the sides.

image

image
image1408×776 124 KB

![image|690x373](upload://tc7rVYPufGJo2nGKNv27tJAU2qn.png

max_date=ExtractDataTable_Invoice.AsEnumerable.Where(Function(r) DateTime.TryParseExact(r(“Date”).ToString,“M/d/yyyy”,System.Globalization.CultureInfo.InvariantCulture,DateTimestyles.None,New DateTime)).Max(Function(r) DateTime.ParseExact(r(“Date”).ToString,“M/d/yyyy”,System.Globalization.CultureInfo.InvariantCulture,DateTimestyles.None)).ToString(“M/d/yyyy”)

CurrentRow(“DATE”).ToString.Equals(“max_date”)

2

Hello @dutta.marina try below
CurrentRow("DATE").ToString = max_date
You should never put your variables in quotes.
Because of quotes, condition was matching strings "03/31/2022"="max_date" which never going to match hence will always go into else.

3

Thanks @AkshaySandhu .It worked

4

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