Error in Linq .Need Help

Help Studio
, ,
1

Hi All,

I am trying to extract the max date from a Data Table. I have rows of Invoices with multiple dates and I need to select the max date. I am trying to scrape the data and put in data table. from there I am using Linq to get the maximum dates. However I am getting error in Linq .

image
image716×382 12.8 KB

Convert.ToDateTime( ((From DataRow CurrentRow In ExtractDataTable_Invoice.Rows Orderby Convert.ToDateTime(CurrentRow[“Date”]) Descending Select CurrentRow).FirstOrDefault()[“Date]”))

image

image
I need to pick the latest date . 7/31/2022 and these dates can vary in run time however I need to pick up the latest dates

image

2

change format accordingly

3

Hi @dutta.marina

Sometimes the Convert.ToDateTime doesn’t Work correctly.

Can you try with the following expression, that might help you.

Datetime.ParseExact(“give your date here”,“M/dd/yyyy”,Gloabalization.CultureInfo.InvariantCulture)

4

Hi,

If you use C#, can you try the following?

Convert.ToDateTime( ((from DataRow CurrentRow in ExtractDataTable_Invoice.Rows orderby Convert.ToDateTime(CurrentRow["Date"]) descending select CurrentRow).FirstOrDefault()["Date"]))

Regards,

5

Hi Yoichi,

I am getting following error.

image
image1744×391 57.8 KB

6

Hi @adiijaiin

I have used DateTime.TryParseExact( ((from DataRow CurrentRow in ExtractDataTable_Invoice.Rows orderby DateTime.TryParseExact(CurrentRow[“Date”]) descending select CurrentRow).FirstOrDefault()[“Date”])) but still getting error.

7

Hi Yoichi,

I tried

image
image1769×509 60.6 KB

but still getting error

8

Hi @adiijaiin

I am getting error.

image
image1769×509 60.6 KB

9

while using ParseExact you need to give the input format of the date as well.

10

Hi,

Can you share your workflow file if possible?
Basically it’s necessary cultureinfo and result argument if you use TryParseExact method.

Regards,

11

Hi Yoichi

Please find the file.Thank You
Date_Time.zip (3.3 KB)

12

Hi @adiijaiin

Is it something which I can write ? Let me know if this is correct. Attached my workflow also.
Date_Time.zip (3.3 KB)

ExtractDataTable_Invoice.AsEnumerable.Where(Function(r) DateTime.TryParseExact(r([“Date”]).ToString,“MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture,DateTimestyles.None,New DateTime)).Max(Function(r) DateTime.ParseExact(r([“Date”]).ToString,“MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture,DateTimestyles.None)).ToString(“MM-dd-yyyy”)

13

Hi,

We cannot open this project correctly. Can you check if can open this?

Regards,

14

@dutta.marina

Can you please confirm if yours is a c# or vb.net project…

Because i see a combination you are using in the code

Cheers

15

@Anil_G

For me its VB.Net

16

Hi @Yoichi

I have uploaded again. Can you check now.
Main.xaml (10.6 KB)

17

@dutta.marina

Then can you please try this please

Cdate(ExtractDataTable_Invoice.AsEnumerable.Where(Function(r) DateTime.TryParseExact(r(("Date")).ToString,“MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture,DateTimestyles.None,New DateTime)).Max(Function(r) DateTime.ParseExact(r("Date").ToString,“MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture,DateTimestyles.None))("Date").ToString).ToString("MM-dd-yyyy")

Cheers

18

@Anil_G

I tried but getting error.

image
image3390×906 209 KB

image
image3390×906 209 KB

19

@dutta.marina

A small correction to the above

ExtractDataTable_Invoice.AsEnumerable.Where(Function(r) DateTime.TryParseExact(r(("Date")).ToString,“MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture,DateTimestyles.None,New DateTime)).Max(Function(r) DateTime.ParseExact(r("Date").ToString,“MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture,DateTimestyles.None)).ToString("MM-dd-yyyy")

Cheers

20

@Anil_G

Thank You very much. Error has gone. But can you please explain the code ?Also why we are using the Function(r)?

Thanks once again