I need to extract datatable from a datatable - dt, where date is greater than 2 months. I used the following query: DateVariable => DateTime Variable dt.AsEnumerable.Where(function(x) DateTime.ParseExact(x(“date”).ToString,“MM/dd/yyyy”,Nothing)<DateVariable) Error: Option Strict on disallowing l…

Try this then…! yourDt.AsEnumerable().Where(Function(row) datetime.ParseExact(row(“DateColumn”).ToString,“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture)>=now.AddMonths(2)).CopyToDatatable @Altavista Thanks!

Filter using Date in DataTable

Help Studio

kadiravan_kalidoss (Kadiravan K) March 17, 2020, 9:16am 2

Dt = dt.Select(“[Date]>= now.AddMonths(2).ToString”).CopyToDataTable() - try this once

@Altavista

Thanks!

Topic		Replies	Views
Select "Date" in datatables Help	9	4119	June 8, 2019
Filter data table by date issue Studio studio , question , activities_panel	5	541	May 22, 2023
How to compare Data table date greater than or not Academy Feedback datatable , activities , question	2	1291	July 6, 2020
Split date time from excel Studio studio , question , activities_panel	4	541	November 10, 2022
How to make it so that if my variable contains any value from a datatable it performs a specific action Studio studio , question , activities_panel	4	396	March 16, 2023

Most Active Users - Yesterday
Anil_G
ashokkarale
Yoichi
Julian3
sharazkm32
minako_tanaka
jast1631
A_Learner
Mr.BENJAMINE_STAIRRIERS
srdjan.suc
More details...

Filter using Date in DataTable

Related topics