how to select null values for DGL in UTB

[srinatherp]

hi!!
i'm new to this forum and as well as JDE, right now i'm working on DEMO.

can anyone tell me how to select non null values in DGL field in UTB?

 

[jacobw123]

>0

 

[Larry_Jones]

1. Native JDE apps don't allow null values in tables.
2. JDE equivalent to a null date value (DGL) is 0 (zero).
3. In UTB with the "Format Data Option" checked just enter your filter as " < 01/01/01 "

 

[Zoltan_Gyimesi]

Hi Larry,

Does it works?
This was my first idea too, but hadn't time to try this.
BTW we can to turn OFF "Format Data" in UTB, but I do knot know, how does this affect filtering in UTB.

Regards,

Zoltán

 

[Larry_Jones]

Works at my release level.

 

[WhippingBoy]

Just do a filter of '<1'. That works too, regardless of the display.