Filter Null Date using SetRange

How do I filter rows, where a field (type : Date) is null?.

SalesPrice.Setrange(“Ending Date”, ‘’);

The above will not work as the give field is not a string, it is date.

Thanks & Regards


NULL does not exist in NAV.

To filter on an empty date value using SETRANGE, use 0D (the number zero, the letter D) as the filter value

Yes. It worked. Thanks Dude.

You’re welcome dude [H]