eyuce
1

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 ?
Anil_G
(Anil Gorthi)
2
@eyuce
you can extract all the data first into datatble using extract to datatable activity and then filter it with date as needed
cheers
eyuce
3
i am sharing screenshots of the error I received
Anil_G
(Anil Gorthi)
4
@eyuce
check this inverted comma it is wrong…remove and re add it

cheers
eyuce
5
i understood the error you mentioned and changed it, but I still got the same error. 
Anil_G
(Anil Gorthi)
6
@eyuce
just to confirm replace all inverted comma and check may be something is wrong in those
cheers
eyuce
7
it worked without any errors, but it did not give the action number.

Anil_G
(Anil Gorthi)
8
@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