Help Filter data Table

Hello, I have a problem when filtering a table.

follow print


I need to filter in column 3 that only show month and year

Hey Camilo,

Your datatable has 3 columns, right?
In this case you will inform column 2, since the indexes of columns in a datatable begin with 0.
Also, you will inform it as an integer. Instead of “2”, put only 2.

You can use a string to inform the column name. In this case you could put “Enviada em” in there, and the filter would work.

I’m assuming your column is of type string, in which case the Contains will work just fine.

Please let me know if it works.

Deu certo Lucas! Segue o print

Aproveitando no campo “08/2021” igual do print consigo colocar Mês/Ano Vigente ? que o robo busque o mês e no vigente ?

Hi @Camilo_Cardoso!

In order to search based on the current month and current year, you can build the “Valor” expression like this:

Now.ToString(“MM/yyyy”)

This will input as of today → “02/2022”

image

Hope it helps!

Best Regards,
Ignasi

Ola Ignasi, Deu certo!

Muito obrigado pela ajuda.

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