Web sitesindeki bir tablodaki tarihlerden eski olanların aksiyon numaralarını listeleme - Listing action numbers from dates older than those in a table on the website

image

Hello,
I want to list the action numbers of the dates that are older than the dates in a table on the website. How can I do that ? (mmmm dd, yyyy)

Merhaba,
Web sitesindeki bir tablodaki tarihlerden eski olanların aksiyon numaralarını listelemek istiyorum. Bunu nasıl yapabilirim ?

@eyuce

you can extract all the data first into datatble using extract to datatable activity and then filter it with date as needed

cheers

i am sharing screenshots of the error I received


image

@eyuce

check this inverted comma it is wrong…remove and re add it

image

cheers

i understood the error you mentioned and changed it, but I still got the same error. :frowning:

@eyuce

just to confirm replace all inverted comma and check may be something is wrong in those

cheers

it worked without any errors, but it did not give the action number.
image

@eyuce

That might be because the column is extracted as string rather than date…

Try with linq as below

RequiredTable = Dt.AsEnumerable.Where(function(x) Datetime.ParseExact(x("Application date").ToString,"MMMM dd,yyyy",System.Globalization.CultureInfo.InvariantCulture)).CopyToDataTable

Cheers

1 Like