DateTime applied as condition in datatable filter activity

Help Activities
, ,
1

Hello, all
I need help. I’m filtering a datatable, and now i must add a new condition to the filter.
I must capture in the table all records from last 6 days until today.
I tried to use this, but the output table has no lines, the original has 5000 lines.
image
Can anyone help please!
Thanks

2

Kindly check the datatype of the column “DATA_CRIACAO”.
Maybe its string so it is unable to compare string with the date provided in value

3

@jose.p.mendes
as far we have understood if the record’s date 6 days old or newer then it should pass the filter, right?

it looks like Operation is filtering the opposite (regardless of maybe other datatype issues)
grafik

4

It’s the first date. Date of DB creation

1 Like
5

I’ve tried to change the operation and has returned 0 lines treated.
image

6

so we are one step further:
the operation is as intended. Now maybe a datatype confusion blocks the current working filter.
So we do know what is on right side (datatype)
for quick checking what is on left side you can do following:

  • place a breakpoint on the filter datatable activity
  • debug an pause
  • use on watch panel ollowing statement
    • yourDataTableVarName.Rows(0)(“DATA_CRIACAO”)
  • share the result of this with us (e.g. as screenshot)
7

Here it is…
image

8

@jose.p.mendes
please use this watch panel:
grafik

9

That’s what i’ve done.
image

if it helps, here is an example of the csv file data.

image
image1197×158 4.42 KB

10

this was the result…

11

ideally it should look similar like this without evaluation issue:
grafik

as an alternate maybe you can share with us like this:
grafik

ensure that the breakpouint is set on a place where the datatble is already filled with data

the best and most direct analysis is to inspect the content of the datatable (visually displayed value in Excel is not a mandatory the same within the datatable. Thats the reason for our request)

12

It’s here…

image
image1482×96 6.42 KB

13

as mentioned click on the pencil (of the corresponding DataTable) then we can see the content. Thanks

14

[COD_CLIENTE,COD_CONTRAT,DESIGNACAO,OBJETO,REF_CLIENT,DT_RECECAO,DATA_ULT_EV,ULT_EVEN,RAZÃO,SITUAÇÃO,PESO,NOME_DEST,MOR_DEST,COD_POST_DEST,NOME_RECETOR,VALOR_COB_DEST,JANELA_HORARIA,DATA_CRIACAO
]

15

image
image1368×308 8.72 KB

16

So datatable is empty / has no rows
Can be also crosschecked on e.g watch panel from above with statement YourDataTableVar.Rows.Count

17

i see…
So the condition is correct…
DateTime.Now.AddDays(-5), it should bring to me all data records between 14-01 and today, right?

18

Best point to rate the situation is once we do know the excatly content within the datatable.
Date/DateTime filter issues can come from:

  • datatype missmatch, lexically ordering, format differences (just to name a few).

However there is a good course offerered on the Academy platform related to Debugging. It introduce a few concepts (you now had used e.g. inspecting the locals, watch panel…) It is highly recommended to have a look on this course as the demonstrated topics will help much for doing analysis on issues etc

19

Thanks, i will follow your advise.
I’m going to take a look at that course.

1 Like
20

Could you please share course link to directly jump