I want to save the invoice if the cell of the row is empty but only the news

hello i want to save only the invoices that are after today for example but in my excel document are some invoices that are empty so i want to save only the lastest invoice that are empty and are after today
this an example i have to save only the row that are empty in fecha_de_carga


First you have to create a Datatable variable - Ex: Out_DT

use this syntax in assign activity

From row In Input_DT
Where (row("Your_Date_Column_Name").ToString)=DateTime.Now.ToString("dd.MM.yyyy")
Select row

the above syntax copy the current date and invoice into Out_DT

Use the variable where you want

Update us whether you got a solution or not
Robin S

1 Like

If its solves your issue can you mark it as solution ao that it will be helpfull to othera also


Can you try the following expression?

dt = dt.AsEnumerable.Where(Function(r) String.IsNullOrWhiteSpace(r("Fecha_de_carga").ToString) OrElse DateTime.ParseExact(r("Fecha_de_carga").ToString,"dd.MM.yyyy",System.Globalization.CultureInfo.InvariantCulture)>=Today.AddDays(1)).CopyToDataTable


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