Remove rows from DT which have date later than a provide date

Help Activities
, , , ,
1

How do i remove rows from a DT where the date string yyyyMMdd from a column is later than the provided date variable, without using for each loop if possible?

date variable = 03052023

date var is in ddMMyyyy

2

Hi @TyraS

Please try the following query in an Assign activity:

filteredRows = yourDt.Select("DateTime.ParseExact(dateColumn, 'ddMMyyyy', System.Globalization.CultureInfo.InvariantCulture) <= DateTime.ParseExact('" + providedDate + "', 'ddMMyyyy', System.Globalization.CultureInfo.InvariantCulture)").CopyToDataTable()

Hope this helps,
Best Regards.

3

Hello @TyraS ,

Try below logic. Hope it helps

(From p In dt.Select() Where (From q In dt.Select() Where DateTime.ParseExact(q("Column1").tostring,"ddMMyyyy",System.Globalization.CultureInfo.InvariantCulture)<(DateTime.ParseExact(p("Column1").tostring,"ddMMyyyy",System.Globalization.CultureInfo.InvariantCulture)) Select q).toArray.count>1 Select p).ToArray.copyTodatatable()

**NOTE : **
dt : is variable of type datatable
“Column1” : is your date column

2 Likes
4

got this error : The expression contains undefined function call DateTime.ParseExact().

5

hi @pavithra_pavi , i tried to modified the code, but it seems to not filter.

(From p In dt.Select() Where (From q In dt.Select() Where DateTime.ParseExact(q(“Column1”).tostring,“yyyyMMdd”,System.Globalization.CultureInfo.InvariantCulture)<(DateTime.ParseExact((DateTime.ParseExact(“01092022”, “ddMMyyyy”, System.Globalization.CultureInfo.InvariantCulture).toString(“yyyyMMdd”)),“yyyyMMdd”,System.Globalization.CultureInfo.InvariantCulture)) Select q).toArray.count>1 Select p).ToArray.copyTodatatable()

6

can you share your code? to understand better.

In my LINQ query, i used “Column1” Does your code has same name for column? If Not, please change it

i.e.,

(From p In dt.Select() Where (From q In dt.Select() Where DateTime.ParseExact(q(“Column1”).tostring,“ddMMyyyy”,System.Globalization.CultureInfo.InvariantCulture)<(DateTime.ParseExact(p(“Column1”).tostring,“ddMMyyyy”,System.Globalization.CultureInfo.InvariantCulture)) Select q).toArray.count>1 Select p).ToArray.copyTodatatable()

7 
dt.AsEnumerable().where(Function (row) DateTime.ParseExact(row("Column1").tostring,"yyyyMMdd",System.Globalization.CultureInfo.InvariantCulture)<=(DateTime.ParseExact(dateVar,"yyyyMMdd",System.Globalization.CultureInfo.InvariantCulture))).CopyToDataTable
8

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