Filter for fields

Business Central/NAV Developers Forum
1

Hello,

I would like to filter the lines of a table, where “End Time” field is blank.

“End Time” field’ type is DateTime.

I tried this:

ItemJnlLine.SETFILTER(“End Time”, ‘<>0D’);

But I get an error message: ‘0D is not a valid date.’

What should I write instead of 0D?

Thanks a lot,

Frida

2

Did you try with 0DT?

3

Yes, I tried.

I have the same error message: ‘0DT is not a valid date’. :frowning:

4

try something like

ItemJnlLine.SETFILTER(“End Time”, ‘<>%1’,‘’);

5

try

ItemJnlLine.SETFILTER(“End Time”, ‘<>%1’,0DT);