How to filter excel file in if-statement

Help Studio
, , , , ,
4

Hi @lope_0238 ,
Try below query
dt.Select("ColumnA='"+Now.ToString("dd/mm/yyyy")+"'").CopyToDataTable()

if you want to put it as if condition try below
dt.Select("ColumnA='"+Now.ToString("dd/mm/yyyy")+"'").length>0

Regrads,
Arivu

1 Like