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

Help Activities
, , , ,
1

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
image
this an example i have to save only the row that are empty in fecha_de_carga

2

Hi @VAZQUEZ_SOSA_LUIS_ALBERTO

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

use this syntax in assign activity


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

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
Thanks,
Robin S

1 Like
3

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

4

Hi,

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

Regards,

5

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